pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/restore ...

PostgreSQL provides various lock modes to control concurrent access to data in tables. These modes can be used for application-controlled locking in situations where MVCC does not give the desired ...

We are excited to announce the release of [pgspot]( 0.8.1, a new version of our vulnerability checker for PostgreSQL SQL ...

There are several password-based authentication methods. These methods operate similarly but differ in how the users' passwords are stored on the server and how the password provided by a client is ...

7.2.3. The GROUP BY and HAVING Clauses The FROM clause derives a table from one or more other tables given in a comma-separated table reference list. When a table reference names a table that is the ...

Aggregate functions compute a single result from a set of input values. The built-in general-purpose aggregate functions are listed in Table 9.59 while statistical aggregates are in Table 9.60. The ...

CREATE TABLE will create a new, initially empty table in the current database. The table will be owned by the user issuing the command. If a schema name is given (for example, CREATE TABLE ...

There are several settings that can cause the query planner not to generate a parallel query plan under any circumstances. In order for any parallel query plans whatsoever to be generated, the ...

This section describes the detailed format of each logical replication message. These messages are returned either by the replication slot SQL interface or are sent by a walsender. In case of a ...

dblink_connect — opens a persistent connection to a remote database dblink_connect_u — opens a persistent connection to a remote database, insecurely dblink_disconnect — closes a persistent connection ...