pg_opclass

A system catalogue table defining index access method operator classes

pg_opclass is a system catalogue table defining index access method operator classes (opclass).

psql command

  • \dAc[+] lists availabke operator classes

Definition by PostgreSQL version

pg_opclass (PostgreSQL 13)

              Table "pg_catalog.pg_opclass"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null |
 opcmethod    | oid     |           | not null |
 opcname      | name    |           | not null |
 opcnamespace | oid     |           | not null |
 opcowner     | oid     |           | not null |
 opcfamily    | oid     |           | not null |
 opcintype    | oid     |           | not null |
 opcdefault   | boolean |           | not null |
 opckeytype   | oid     |           | not null |
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 12)

              Table "pg_catalog.pg_opclass"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 oid          | oid     |           | not null |
 opcmethod    | oid     |           | not null |
 opcname      | name    |           | not null |
 opcnamespace | oid     |           | not null |
 opcowner     | oid     |           | not null |
 opcfamily    | oid     |           | not null |
 opcintype    | oid     |           | not null |
 opcdefault   | boolean |           | not null |
 opckeytype   | oid     |           | not null |
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 11)

              Table "pg_catalog.pg_opclass"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 opcmethod    | oid     |           | not null |
 opcname      | name    |           | not null |
 opcnamespace | oid     |           | not null |
 opcowner     | oid     |           | not null |
 opcfamily    | oid     |           | not null |
 opcintype    | oid     |           | not null |
 opcdefault   | boolean |           | not null |
 opckeytype   | oid     |           | not null |
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 10)

              Table "pg_catalog.pg_opclass"
    Column    |  Type   | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
 opcmethod    | oid     |           | not null |
 opcname      | name    |           | not null |
 opcnamespace | oid     |           | not null |
 opcowner     | oid     |           | not null |
 opcfamily    | oid     |           | not null |
 opcintype    | oid     |           | not null |
 opcdefault   | boolean |           | not null |
 opckeytype   | oid     |           | not null |
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.6)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.5)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.4)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.3)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.2)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.1)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 9.0)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 8.4)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 8.3)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcmethod    | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcfamily    | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcmethod, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

pg_opclass (PostgreSQL 8.2)

   Table "pg_catalog.pg_opclass"
    Column    |  Type   | Modifiers
--------------+---------+-----------
 opcamid      | oid     | not null
 opcname      | name    | not null
 opcnamespace | oid     | not null
 opcowner     | oid     | not null
 opcintype    | oid     | not null
 opcdefault   | boolean | not null
 opckeytype   | oid     | not null
Indexes:
    "pg_opclass_am_name_nsp_index" UNIQUE, btree (opcamid, opcname, opcnamespace)
    "pg_opclass_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opclass

Change history

Note: any changes prior to PostgreSQL 7.3 are not reflected in this list.

Categories

Indexing, System catalogue

See also

pg_amop, pg_amproc, pg_opfamily, CREATE OPERATOR CLASS