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 an entire cluster.
Name | Type | Reference | Description |
|---|---|---|---|
objoid | oid | Any OID column | OID of the object that this description pertains to |
classoid | oid | oid in PG_CLASS | 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.
