PostgreSQL regex testing

Regular Expression

Replacement

Options Help

rest of RE is a BRE (b)

case-sensitive matching (overrides operator type) (c)

rest of RE is an ERE (e)

case-insensitive matching (overrides operator type) (i)

historical synonym for n (m)

newline-sensitive matching (n)

partial newline-sensitive matching (p)

rest of RE is a literal ("quoted") string, all ordinary characters (q)

non-newline-sensitive matching (default) (s)

tight syntax (t)

inverse partial newline-sensitive ("weird") matching (w)

expanded syntax (x)

PostgreSQL Regular Expression Test Page