XML Functions
  • References/Database/PostgreSQL/Functions/XML

The functions and function-like expressions described in this section operate on values of type xml. Check

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

This feature was designed to allow parameters not normally known to PostgreSQL to be added by add-on modules (such as procedural languages)

2025-01-10 15:47:30
User Name Maps
  • References/Database/PostgreSQL/Client Authentication

When using an external authentication system such as Ident or GSSAPI, the name of the operating system user that initiated the connection might not be the same as the database

2025-01-10 15:47:30
Value Expressions
  • References/Database/PostgreSQL/Syntax

Value expressions are used in a variety of contexts, such as in the target list of the SELECT command, as new column values in

2025-01-10 15:47:30
Managing Kernel Resources
  • References/Database/PostgreSQL/Server Setup and Operation

PostgreSQL can sometimes exhaust various operating system resource limits, especially when multiple copies of the server are running on the

2025-01-10 15:47:30
Internals: How Connections are Established
  • References/Database/PostgreSQL/Internals

PostgreSQL is implemented using a simple "process per user" client/server model. In this model there is one

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
DROP USER MAPPING
  • References/Database/PostgreSQL/Commands

NameDROP USER MAPPING -- remove a user mapping for a foreign server Synopsis

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

The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values

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