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
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
tsm_system_rows
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the

2025-01-10 15:47:30
Enum Functions
  • References/Database/PostgreSQL/Functions and Operators

For enum types (described in Section 8.7), there are several functions that allow cleaner programming

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

NameABORT -- abort the current transaction Synopsis

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
ALTER OPERATOR CLASS
  • References/Database/PostgreSQL/Commands

NameALTER OPERATOR CLASS -- change the definition of an operator class Synopsis

2025-01-10 15:47:30
SQL Key Words
  • References/Database/PostgreSQL/Appendixes/Appendixes

Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.6.0. Background information can be found in Section 4

2025-01-10 15:47:30
2.
  • References/Database/PostgreSQL/Tutorial/Getting Started

Before we proceed, you should understand the basic PostgreSQL system architecture. Understanding how the parts of PostgreSQL

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

The catalog pg_range stores information about range types. This is in addition to the types' entries in

2025-01-10 15:47:30