Catalogs: pg_group
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

2025-01-10 15:47:30
pg_recvlogical
  • References/Database/PostgreSQL/Applications

Namepg_recvlogical -- control PostgreSQL logical decoding streams

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

NameDROP FUNCTION -- remove a function Synopsis

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

The view pg_user provides access to information about database users. This is simply a publicly readable view of

2025-01-10 15:47:30
Role Membership
  • References/Database/PostgreSQL/Database Roles

It is frequently convenient to group users together to ease management of privileges: that way, privileges can be granted to, or revoked from, a group as a whole. In

2025-01-10 15:47:30
Internals//Physical Storage: Free Space Map
  • References/Database/PostgreSQL/Internals/Physical Storage

Each heap and index relation, except for hash indexes, has a Free Space Map (FSM) to keep track of available space in the relation. It's stored alongside the main relation

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

NameALTER LANGUAGE -- change the definition of a procedural language Synopsis

2025-01-10 15:47:30
Type Conversion: UNION, CASE, and Related Constructs
  • References/Database/PostgreSQL/Type Conversion

SQL UNION constructs must match up possibly dissimilar types to become a single result set. The resolution algorithm is applied separately to each

2025-01-10 15:47:30
XML Type
  • References/Database/PostgreSQL/Data Types

The xml data type can be used to store XML data. Its advantage over storing XML data in a text field is that it checks the

2025-01-10 15:47:30
Encryption Options
  • References/Database/PostgreSQL/Server Setup and Operation

PostgreSQL offers encryption at several levels, and provides flexibility in protecting data from disclosure due to database server theft, unscrupulous

2025-01-10 15:47:30