select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_description

Read PG 18 manual ↗

The catalog pg_description stores optional descriptions (comments) for each database object.

Kind
System catalogs
Columns in this snapshot
4
Definition source
English manual

Columns 4

ColumnTypeDescription / reference
objoidoidThe OID of the object this description pertains to
classoidoidThe OID of the system catalog this object appears in
pg_class.oid
objsubidint4For a comment on a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.
descriptiontextArbitrary text that serves as the description of this object
Column history across versions

Definition snapshot: english-manuals:2c464ef7ac2189cdd0bcdd75f5e… · English manual source