PG_DESCRIPTION
PG_DESCRIPTION records optional descriptions (comments) for each database object. Descriptions of many built-in system objects are provided in the initial contents of PG_DESCRIPTION.
See also PG_SHDESCRIPTION, which provides a similar function for descriptions involving objects that are shared across a database cluster.
| Name | Type | Reference | Description |
|---|---|---|---|
| objoid | oid | Any OID column | OID of the object that this description pertains to |
| classoid | oid | PG_CLASS.oid | OID of the system catalog where the object appears |
| objsubid | integer | - | Column number for a comment on a table column (objoid and classoid refer to the table itself); 0 for all other object types |
| description | text | - | Arbitrary text that serves as the description of the object |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
