pg_opclass

A system table containing definitions for index access method opclasses

pg_opclass is a system catalogue table containing definitions for index access method operator classes (opclass).

psql command

  • \dAc[+] lists available operator classes

Definition by PostgreSQL version

pg_opclass (PostgreSQL 14)

              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_oid_index" PRIMARY KEY, btree (oid)
    "pg_opclass_am_name_nsp_index" UNIQUE CONSTRAINT, btree (opcmethod, opcname, opcnamespace)
    

Documentation: pg_opclass

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