Catalogs: pg_opfamily
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement

2025-01-10 15:47:30
Registering Event Log on Windows
  • References/Database/PostgreSQL/Server Setup and Operation

To register a Windows event log library with the operating system, issue this command:

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

Namepg_restore -- restore a PostgreSQL database from an archive file created by pg_dump

2025-01-10 15:47:30
Arrays
  • References/Database/PostgreSQL/Data Types

PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base

2025-01-10 15:47:30
File System Level Backup
  • References/Database/PostgreSQL/Backup and Restore

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

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

NameCREATE SERVER -- define a new foreign server Synopsis

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

The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database

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

NameCLUSTER -- cluster a table according to an index Synopsis

2025-01-10 15:47:30
Performance Tips: Statistics Used by the Planner
  • References/Database/PostgreSQL/Performance Tips

As we saw in the previous section, the query planner needs to estimate the number of rows retrieved by a query in order to make good choices of query plans. This section provides

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

NameALTER SERVER -- change the definition of a foreign server Synopsis

2025-01-10 15:47:30