pg_description
stores descriptions (comments) for each database object. It mimics the pg_description PostgreSQL system catalog.
pg_description
are applicable to every type of relation.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 |