PostgreSQL: Regular expressions and pattern matching A regular expression is a special text string used to describe a search pattern. PostgreSQL’s regular expressions supports three separate approaches to pattern matching: POSIX-style regular expressions (BREs and EREs)... July 31, 2019
