pg_description

PostgreSQL 7.3.4 Documentation
Prev | Chapter 3. System Catalogs | Next

# 3.14. pg_description

The pg_description table can store an optional description or comment for each database object. Descriptions can be manipulated with the `COMMENT` command and viewed with psql's \d commands. Descriptions of many built-in system objects are provided in the initial contents of pg_description.

Table 3-14. pg_description Columns

Name | Type | References | Description
--- | --- | --- | ---
objoid | `oid` | any oid attribute | The oid of the object this description pertains to
classoid | `oid` | pg_class.oid | The oid of the system catalog this object appears in
objsubid | `int4` |  | For a comment on a table attribute, this is the attribute's column number (the objoid and classoid refer to the table itself). For all other object types, this field is presently zero.
description | `text` |  | Arbitrary text that serves as the description of this object.

Prev | Home | Next
pg_depend | Up | pg_group