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

Categories

DDL, System catalogue

See also

COMMENT ON, pg_shdescription