System Catalogs
pg_description
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
:
Column | Type | Description |
---|---|---|
objoid | int | This column represents the OID (Object ID) of the object for which the description is stored |
classoid | int | This column represents the OID of the table that the object belongs to |
objsubid | int | If an object has multiple parts (for example, columns in a table), objsubid specifies the column number. If not used, this is set to 0 |
description | text | This column represents the description for the specified object |