An alternative backup strategy is to directly copy the files that PostgreSQL uses to store the data in the database;

Internally, a GIN index contains a B-tree index constructed over keys, where each key is an element of one or more indexed items (a member

NameALTER DEFAULT PRIVILEGES -- define default access privileges Synopsis

PostgreSQL provides the standard SQL type boolean; see Table 8-19. The

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning

See Section 8.17 for an overview of range types. Table 9-49 shows

The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each

The catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database

NameREFRESH MATERIALIZED VIEW -- replace the contents of a materialized view Synopsis

NameCOMMIT PREPARED -- commit a transaction that was earlier prepared for two-phase commit