www.regexplanet.com
Open in
urlscan Pro
2606:4700:3036::ac43:80f1
Public Scan
Submitted URL: http://regexplanet-postgresql.herokuapp.com/
Effective URL: https://www.regexplanet.com/advanced/postgresql/index.html
Submission: On June 06 via api from GB — Scanned from GB
Effective URL: https://www.regexplanet.com/advanced/postgresql/index.html
Submission: On June 06 via api from GB — Scanned from GB
Form analysis
1 forms found in the DOMName: testform — POST index.html
<form action="index.html" class="form-horizontal" id="testform" method="POST" name="testform">
<input type="hidden" name="key" value="">
<input type="hidden" name="edit" value="N">
<input type="hidden" name="engine" value="postgresql">
<legend>Expression to test</legend>
<div class="form-group">
<label class="col-sm-3 control-label" for="regex">Regular expression:</label>
<div class="col-sm-9">
<textarea id="regex" class="form-control" type="text" rows="1" name="regex"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" id="optionsCheckboxes">Options:</label>
<div class="col-sm-9">
<div class="checkbox"><label><input type="checkbox" name="option" value="b"> b - rest of RE is a BRE</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="c"> c - case-sensitive matching (overrides operator type)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="e"> e - rest of RE is an ERE</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="i"> i - case-insensitive matching (see Section 9.7.3.5) (overrides operator type)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="m"> m - historical synonym for n</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="n"> n - newline-sensitive matching (see Section 9.7.3.5)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="p"> p - partial newline-sensitive matching (see Section 9.7.3.5)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="q"> q - rest of RE is a literal ("quoted") string, all ordinary characters</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="s"> s - non-newline-sensitive matching (default)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="t"> t - tight syntax (default; see below)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="w"> w - inverse partial newline-sensitive ("weird") matching (see Section 9.7.3.5)</label></div>
<div class="checkbox"><label><input type="checkbox" name="option" value="x"> x - expanded syntax (see below)</label></div>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="replacement">Replacement:</label>
<div class="col-sm-9">
<input id="replacement" class="form-control" name="replacement" size="30" type="text" value="">
</div>
</div>
<div class="form-group">
<div class="col-sm-3"></div>
<div class="col-sm-9">
<input class="btn btn-primary" type="submit" value="Test">
<input class="btn btn-default moreinput" type="submit" value="More Inputs">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="input1">Input 1:</label>
<div class="col-sm-8">
<textarea class="form-control" id="input1" name="input" rows="1"></textarea>
<input type="hidden" id="target1" name="target" value="">
</div>
<div class="col-sm-1">
<a class="btn btn-default btn-xs targetedit" id="targetedit1"><i class="fa fa-cogs"></i></a>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="input2">Input 2:</label>
<div class="col-sm-8">
<textarea class="form-control" id="input2" name="input" rows="1"></textarea>
<input type="hidden" id="target2" name="target" value="">
</div>
<div class="col-sm-1">
<a class="btn btn-default btn-xs targetedit" id="targetedit2"><i class="fa fa-cogs"></i></a>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="input3">Input 3:</label>
<div class="col-sm-8">
<textarea class="form-control" id="input3" name="input" rows="1"></textarea>
<input type="hidden" id="target3" name="target" value="">
</div>
<div class="col-sm-1">
<a class="btn btn-default btn-xs targetedit" id="targetedit3"><i class="fa fa-cogs"></i></a>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="input4">Input 4:</label>
<div class="col-sm-8">
<textarea class="form-control" id="input4" name="input" rows="1"></textarea>
<input type="hidden" id="target4" name="target" value="">
</div>
<div class="col-sm-1">
<a class="btn btn-default btn-xs targetedit" id="targetedit4"><i class="fa fa-cogs"></i></a>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" for="input5">Input 5:</label>
<div class="col-sm-8">
<textarea class="form-control" id="input5" name="input" rows="1"></textarea>
<input type="hidden" id="target5" name="target" value="">
</div>
<div class="col-sm-1">
<a class="btn btn-default btn-xs targetedit" id="targetedit5"><i class="fa fa-cogs"></i></a>
</div>
</div>
<div id="buttondiv" class="form-group">
<div class="col-sm-3"></div>
<div class="col-sm-9">
<input class="btn btn-primary" type="submit" value="Test">
<input class="btn btn-default moreinput" type="submit" value="More Inputs">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">
<i class="fa fa-question-circle helptip xpopover-dismiss" data-container="body" data-toggle="popover" data-content="Create a share code to share this regular expression, options, replacement and all test inputs.<br/><br/>Note that shared regexs are visible to everyone, so do not share anything that is private!" data-html="true" data-placement="top" data-title="Share!" data-original-title="" title=""></i>
</label>
<div class="col-sm-9">
<input class="btn btn-default" id="makeshare" type="submit" value="Make share code">
<span id="sharemessage"></span>
</div>
</div>
<div style="display:none;" class="control-group">
<label class="control-label">
<i class="fa fa-question-circle helptip" data-toggle="popover" data-content="Use the cookbook to save and share regex recipes.<br/><br/>Note: while you can view anonymously, you must be logged in to save." data-title="The Regex Cookbook" data-original-title="" title=""></i>
<b>Cookbook:</b></label>
<div class="controls">
<input type="hidden" id="cbaction" name="cbaction" value="">
<a class="btn" href="#" id="cbview" style="display: none;">View Recipe</a>
<input class="btn" id="cbadd" type="submit" value="Add">
<input class="btn disabled" id="cbsave" type="submit" value="Update" style="display: none;">
<input class="btn" id="cbfork" type="submit" value="Fork" style="display: none;">
<span id="cbmessage"></span>
</div>
</div>
</form>
Text Content
Toggle navigation RegexPlanet * Testing * Go (beta) * Haskell (beta) * Java * JavaScript * .Net * Perl (beta) * PHP (beta) * PostgreSQL (beta) * Python * Ruby (beta) * Tcl (beta) * XRegExp (beta) * * Previous version * Cookbook * Support Pattern Matching docs REGULAR EXPRESSION TEST PAGE FOR POSTGRESQL Share: Online testing with the PostgreSQL engine is still in beta. TEST RESULTS Expression to test Regular expression: Options: b - rest of RE is a BRE c - case-sensitive matching (overrides operator type) e - rest of RE is an ERE i - case-insensitive matching (see Section 9.7.3.5) (overrides operator type) m - historical synonym for n n - newline-sensitive matching (see Section 9.7.3.5) p - partial newline-sensitive matching (see Section 9.7.3.5) q - rest of RE is a literal ("quoted") string, all ordinary characters s - non-newline-sensitive matching (default) t - tight syntax (default; see below) w - inverse partial newline-sensitive ("weird") matching (see Section 9.7.3.5) x - expanded syntax (see below) Replacement: Input 1: Input 2: Input 3: Input 4: Input 5: Cookbook: View Recipe ×Close DESIRED RESULT This is just an experiment and does not do anything yet! Target pairs in the string: Save Cancel License | Privacy Policy | Terms of Service