System Catalogs / System catalogs
pg_description
Read the PG 18 manualThe catalog pg_description stores optional descriptions (comments) for each database object.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
objoid | oidNOT NULL | The OID of the object this description pertains to |
classoid | oidNOT NULL | The OID of the system catalog this object appears in pg_class.oid |
objsubid | int4NOT NULL | For 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. |
description | textNOT NULL | Arbitrary text that serves as the description of this object |
Column history across versions
Definition snapshot: english-manuals:d59e2bd55537c8f38b51ee3659f… · English manual source