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

Form analysis 1 forms found in the DOM

Name: testformPOST 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