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