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 performs 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 this description pertains to |
| classoid | oid | PG_CLASSoid | OID of the system catalog this object appears in |
| objsubid | integer | - | For a comment on a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is 0. |
| description | text | - | Arbitrary text that serves as the description of this object |
Last Article: PG_DEPEND
Next Article: PG_DIRECTORY
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.