Catalogs
pg_description
Catalogs
pg_description
Overview
The pg_description stores descriptions (comments) for each database object. It mimics the pg_description PostgreSQL system catalog.
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 |