Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

IntermediateString Functions

REGEXP_MATCHES: extract all regex matches

SQL

SELECT
  description,
  REGEXP_MATCHES(description, '\d+', 'g') AS numbers_found
FROM products;

Tested against PostgreSQL 16

Note

“REGEXP_MATCHES with 'g' returns a set of all matches. Returns arrays.