The examples shown below use tables in the PostgreSQL regression test database. The outputs shown are taken from version 8.3. The behavior

NameCREATE TEXT SEARCH TEMPLATE -- define a new text search template Synopsis

NameDEALLOCATE -- deallocate a prepared statement Synopsis

NameDROP TEXT SEARCH PARSER -- remove a text search parser Synopsis

btree_gin provides sample GIN operator classes that implement B-tree equivalent behavior for the data types int2,

It is possible to control the query planner to some extent by using the explicit JOIN syntax. To see why this matters, we first need some background

PostgreSQL provides two data types that are designed to support full text search, which is the activity of searching through a collection of

NameCREATE POLICY -- define a new row level security policy for a table Synopsis

Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a

When you create complex database structures involving many tables with foreign key constraints, views, triggers, functions, etc. you implicitly create a net of dependencies