vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0586.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

5.5 KiB
Raw Permalink Blame History

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.

Table 1 PG_DESCRIPTION columns

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
Parent topic: System Catalogs