Overview

The pg_description stores descriptions (comments) for each database object. It mimics the PostgreSQL system catalog pg_description.

Columns

This table is designed for compatibility with tools that require PostgreSQL system tables, so it mostly has dummy data. Please note that not all columns in pg_description are applicable to every type of relation.

The following columns are available for querying in pg_description:

ColumnTypeDescription
objoidintThis column represents the OID (Object ID) of the object for which the description is stored
classoidintThis column represents the OID of the table that the object belongs to
objsubidintIf an object has multiple parts (for example, columns in a table), objsubid specifies the column number. If not used, this is set to 0
descriptiontextThis column represents the description for the specified object