Server Configuration: Version and Platform Compatibility
  • References/Database/PostgreSQL/Server Configuration

19.13.1. Previous PostgreSQL Versions array_nulls (

2025-01-10 15:47:30
System Columns
  • References/Database/PostgreSQL/Data Definition

Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns

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

NameALTER CONVERSION -- change the definition of a conversion Synopsis

2025-01-10 15:47:30
DROP FOREIGN TABLE
  • References/Database/PostgreSQL/Commands

NameDROP FOREIGN TABLE -- remove a foreign table Synopsis

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

The view pg_tables provides access to useful information about each table in the database.

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

Namepg_config -- retrieve information about the installed version of PostgreSQL

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

Nameclusterdb -- cluster a PostgreSQL database

2025-01-10 15:47:30
Full Text Search: GIN and GiST Index Types
  • References/Database/PostgreSQL/Full Text Search

There are two kinds of indexes that can be used to speed up full text searches. Note that indexes are not mandatory for full text searching, but in cases where a column is

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

Range types are data types representing a range of values of some element type (called the range's subtype). For instance, ranges of

2025-01-10 15:47:30
Internals//Genetic Query Optimizer: Query Handling as a Complex Optimization Problem
  • References/Database/PostgreSQL/Internals/Genetic Query Optimizer

Among all relational operators the most difficult one to process and optimize is the join. The number of possible query plans grows exponentially with

2025-01-10 15:47:30