The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

Once you have created a database, you can access it by: Running the PostgreSQL

The core PostgreSQL distribution includes the GIN operator classes shown in Table 63-1. (Some of the optional

NameROLLBACK TO SAVEPOINT -- roll back to a savepoint 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

The GIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type

The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the

unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output

Rows can be removed from a table using the DELETE command. Suppose you are no longer interested in the weather of Hayward. Then you can do the

These settings control the behavior of the built-in streaming replication feature (see Section 26.2.5). Servers will be either a Master or a Standby