Like most other relational database products, PostgreSQL supports aggregate functions. An aggregate function computes

NameDELETE -- delete rows of a table Synopsis

This section describes functions for operating on sequence objects, also called sequence generators or just sequences. Sequence objects are special

NameRESET -- restore the value of a run-time parameter to the default value Synopsis

The results of two queries can be combined using the set operations union, intersection, and difference. The syntax is

NameCREATE VIEW -- define a new view Synopsis

Namepg_rewind -- synchronize a PostgreSQL data directory with another data directory that was forked from it

PostgreSQL supports the full set of SQL date and time types, shown in Table 8-9. The operations available

Shared Disk Failover Shared disk failover avoids synchronization overhead by having only one copy of the database. It uses a single

The modification of data that is already in the database is referred to as updating. You can update individual rows, all the rows in a table, or a subset of all rows. Each