ALTER TABLE
  • References/Database/PostgreSQL/Commands

NameALTER TABLE -- change the definition of a table Synopsis

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

The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the

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

GIN stands for Generalized Inverted Index. GIN is designed for handling cases where the items to be indexed

2025-01-10 15:47:30
Server Configuration: Short Options
  • References/Database/PostgreSQL/Server Configuration

For convenience there are also single letter command-line option switches available for some parameters. They are described in Table 19-2. Some of these options exist for historical

2025-01-10 15:47:30
Partial Indexes
  • References/Database/PostgreSQL/Indexes

A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate

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

The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each

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

NameNOTIFY -- generate a notification Synopsis

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

This module implements a data type seg for representing line segments, or floating point intervals. seg can represent uncertainty

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

The view pg_views provides access to useful information about each view in the database.

2025-01-10 15:47:30