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

The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a

2025-01-10 15:47:30
Indexes on Expressions
  • References/Database/PostgreSQL/Indexes

An index column need not be just a column of the underlying table, but can be a function or scalar expression computed from one or more columns of the table. This feature is

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

Nameclusterdb -- cluster a PostgreSQL database

2025-01-10 15:47:30
Server Configuration: Replication
  • References/Database/PostgreSQL/Server Configuration

These settings control the behavior of the built-in streaming replication feature (see Section 26.2.5). Servers will be either a Master or a Standby

2025-01-10 15:47:30
Destroying a Database
  • References/Database/PostgreSQL/Managing Databases

Databases are destroyed with the command DROP DATABASE:

2025-01-10 15:47:30
intarray
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support for

2025-01-10 15:47:30
Internals//Genetic Query Optimizer: Further Reading
  • References/Database/PostgreSQL/Internals/Genetic Query Optimizer

The following resources contain additional information about genetic algorithms:

2025-01-10 15:47:30
xml2
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The xml2 module provides XPath querying and XSLT functionality. F.46.1. Deprecation

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

NameALTER SYSTEM -- change a server configuration parameter Synopsis

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

Reliability is an important property of any serious database system, and PostgreSQL does everything possible to guarantee reliable operation

2025-01-10 15:47:30