PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
Regular expressions can now be indexed using GIN in pg_trgm.
pg_trgm