RegexPlanet: online regular expression testing for PostgreSQL

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:

Regular Expression Test Page for PostgreSQL