Logical Operators
  • References/Database/PostgreSQL/Functions and Operators

The usual logical operators are available: AND OR

2025-01-10 15:47:30
Catalogs: pg_available_extensions
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_available_extensions view lists the extensions that are available for installation. See also the

2025-01-10 15:47:30
Type Conversion: Operators
  • References/Database/PostgreSQL/Type Conversion

The specific operator that is referenced by an operator expression is determined using the following procedure. Note that this procedure is indirectly affected by the precedence

2025-01-10 15:47:30
PREPARE
  • References/Database/PostgreSQL/Commands

NamePREPARE -- prepare a statement for execution Synopsis

2025-01-10 15:47:30
Catalogs: pg_replication_origin
  • References/Database/PostgreSQL/Internals: Catalogs

The pg_replication_origin catalog contains all replication origins created. For more on replication origins see Chapter 48.

2025-01-10 15:47:30
ALTER COLLATION
  • References/Database/PostgreSQL/Commands

NameALTER COLLATION -- change the definition of a collation Synopsis

2025-01-10 15:47:30
Secure TCP/IP Connections with SSH Tunnels
  • References/Database/PostgreSQL/Server Setup and Operation

It is possible to use SSH to encrypt the network connection between clients and a PostgreSQL server. Done

2025-01-10 15:47:30
CREATE DATABASE
  • References/Database/PostgreSQL/Commands

NameCREATE DATABASE -- create a new database Synopsis

2025-01-10 15:47:30
pg_dump
  • References/Database/PostgreSQL/Applications

Namepg_dump -- extract a PostgreSQL database into a script file or other archive file

2025-01-10 15:47:30
WAL Configuration
  • References/Database/PostgreSQL/Write-Ahead Log

There are several WAL-related configuration parameters that affect database performance. This section explains their use. Consult Chapter

2025-01-10 15:47:30