Advanced text methods

Learn to use regex and full-text search in PostgreSQL to filter and find all types of text patterns

Published

February 13, 2024

Modified

February 13, 2024

Currently in DRAFT

How to use Regex

Common regex expressions

Start and end

Digit

Spaces

Text

Multiple occurrences

Multiple options

Multiline

Case sensitivity

Lookahead

Negative Lookahead

Multiple matches

Groups

Text tokenization

Exercises

Solve them in the query editor.