pg_description
A system catalogue table storing comments for database objects
pg_description is a system catalogue table storing comments for database objects.
pg_description was added in PostgreSQL 6.3 (commit 5071ae29).
Definition by PostgreSQL version
pg_description (PostgreSQL 13)
Table "pg_catalog.pg_description"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
objoid | oid | | not null |
classoid | oid | | not null |
objsubid | integer | | not null |
description | text | C | not null |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 12)
Table "pg_catalog.pg_description"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
objoid | oid | | not null |
classoid | oid | | not null |
objsubid | integer | | not null |
description | text | C | not null |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 11)
Table "pg_catalog.pg_description"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
objoid | oid | | not null |
classoid | oid | | not null |
objsubid | integer | | not null |
description | text | | not null |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 10)
Table "pg_catalog.pg_description"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
objoid | oid | | not null |
classoid | oid | | not null |
objsubid | integer | | not null |
description | text | | not null |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.6)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text | not null
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.5)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text | not null
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.4)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.3)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.2)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.1)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 9.0)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 8.4)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 8.3)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
pg_description (PostgreSQL 8.2)
Table "pg_catalog.pg_description"
Column | Type | Modifiers
-------------+---------+-----------
objoid | oid | not null
classoid | oid | not null
objsubid | integer | not null
description | text |
Indexes:
"pg_description_o_c_o_index" UNIQUE, btree (objoid, classoid, objsubid)
Documentation: pg_description
Change history
- PostgreSQL 7.2
- following columns added (commit bf56f075):
classoidobjsubid
- following columns added (commit bf56f075):
- PostgreSQL 6.3
- added (commit 5071ae29)
References
- PostgreSQL documentation: pg_description