PostgreSQL – Full Text Search – Day 1

Background Let us play with Full Text Search against our PostgreSQL table. Table Query Traditional Query Find Verses :- Jesus and Peter SQL Output Full Text Query Find Verses :- Jesus and Peter Outline to_tsvector([column-name]) to_tsvector(verse) to_tsquery Syntax :- to_tsquery([operand]) Sample :- to_tsquery('(Jesus & Peter)')) SQL Output ' Query Plan Indexes Functional indexes can be … Continue reading PostgreSQL – Full Text Search – Day 1

PostgreSQL – Metadata – Index Columns

Background Admitting nothing real, nor original. I am just trying to close out this Chrome Tab that showcases the best of Stack Overflow. Stack Overflow Luke Francl List columns with indexes in PostgreSQL Link SQL Outline Tables pg_catalog.pg_class pg_catalog.pg_namespace pg_class.relnamespace = pg_namespace.oid pg_catalog.pg_index pg_class.relnamespace = pg_index.indrelid pg_catalog.pg_attribute pg_attribute.attrelid = pg_index.indrelid and pg_attribute.attnum = any(pg_index.indkey) Columns … Continue reading PostgreSQL – Metadata – Index Columns