Options for PostgreSQL Regular Expressions


OptionDescriptionBackend valuePortable value
brest of RE is a BREb(not portable)
ccase-sensitive matching (overrides operator type)c(not portable)
erest of RE is an EREe(not portable)
icase-insensitive matching (overrides operator type)iignorecase
mhistorical synonym for nm(not portable)
nnewline-sensitive matchingn(not portable)
ppartial newline-sensitive matchingp(not portable)
qrest of RE is a literal (“quoted”) string, all ordinary charactersq(not portable)
snon-newline-sensitive matching (default)s(not portable)
ttight syntaxt(not portable)
winverse partial newline-sensitive (“weird”) matchingw(not portable)
xexpanded syntaxx(not portable)