Composite Types
  • References/Database/PostgreSQL/Data Types

A composite type represents the structure of a row or record; it is essentially just a list of field names and their data types.

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

The catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database

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

NameALTER DOMAIN -- change the definition of a domain Synopsis

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

The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all

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

The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser

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
pg_isready
  • References/Database/PostgreSQL/Applications

Namepg_isready -- check the connection status of a PostgreSQL server

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

NameDROP FUNCTION -- remove a function Synopsis

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

NameCREATE TYPE -- define a new data type Synopsis

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