Authentication Problems
  • References/Database/PostgreSQL/Client Authentication

Authentication failures and related problems generally manifest themselves through error messages like the following:

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

The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run

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

The tsearch2 module provides backwards-compatible text search functionality for applications that used tsearch2

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
UUID Type
  • References/Database/PostgreSQL/Data Types

The data type uuid stores Universally Unique Identifiers (UUID) as defined by RFC 4122, ISO/IEC 9834-8:2005, and related standards. (Some systems

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

NameSTART TRANSACTION -- start a transaction block 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
CREATE LANGUAGE
  • References/Database/PostgreSQL/Commands

NameCREATE LANGUAGE -- define a new procedural language Synopsis

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

NameCREATE FOREIGN TABLE -- define a new foreign table Synopsis

2025-01-10 15:47:30
Function and Trigger Security
  • References/Database/PostgreSQL/Database Roles

Functions and triggers allow users to insert code into the backend server that other users might execute unintentionally. Hence, both mechanisms permit users to "Trojan

2025-01-10 15:47:30