Default Values
  • References/Database/PostgreSQL/Data Definition

A column can be assigned a default value. When a new row is created and no values are specified for some of the columns, those columns will be filled with their respective

2025-01-10 15:47:30
Event Trigger Functions
  • References/Database/PostgreSQL/Functions/Event Trigger

PostgreSQL provides these helper functions to retrieve information from event triggers. For more information

2025-01-10 15:47:30
Locale Support
  • References/Database/PostgreSQL/Localization

Locale support refers to an application respecting cultural preferences regarding alphabets, sorting, number formatting, etc.

2025-01-10 15:47:30
Internals//GiST Indexes: Implementation
  • References/Database/PostgreSQL/Internals/GiST Indexes

61.4.1. GiST buffering build Building large GiST indexes by simply inserting all the tuples tends to be slow, because if the index

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
ROLLBACK TO SAVEPOINT
  • References/Database/PostgreSQL/Commands

NameROLLBACK TO SAVEPOINT -- roll back to a savepoint Synopsis

2025-01-10 15:47:30
Explicit Locking
  • References/Database/PostgreSQL/Concurrency Control

PostgreSQL provides various lock modes to control concurrent access to data in tables. These modes can be used for application-controlled locking

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

NameCREATE OPERATOR -- define a new operator Synopsis

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

NameCREATE COLLATION -- define a new collation Synopsis

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