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

NameDROP EXTENSION -- remove an extension Synopsis

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
Text Search Functions and Operators
  • References/Database/PostgreSQL/Functions/Text Search

Table 9-39, Table 9-40 and Table 9-41 summarize the functions and operators that are provided for full text searching. See Chapter 12 for a detailed explanation of

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

NameDROP SCHEMA -- remove a schema Synopsis

2025-01-10 15:47:30