This section describes the SQL-compliant conditional expressions available in PostgreSQL.

NameDROP AGGREGATE -- remove an aggregate function Synopsis

The tsearch2 module provides backwards-compatible text search functionality for applications that used tsearch2

NameDROP EXTENSION -- remove an extension Synopsis

There are two kinds of indexes that can be used to speed up full text searches. Note that indexes are not mandatory for full text searching, but in cases where a column is

PostgreSQL is implemented using a simple "process per user" client/server model. In this model there is one

When you create a table and you realize that you made a mistake, or the requirements of the application change, you can drop the table and create it again. But this is not

Among all relational operators the most difficult one to process and optimize is the join. The number of possible query plans grows exponentially with

NameALTER GROUP -- change role name or membership Synopsis

The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL