pg_opfamily

A system catalogue table defining operator families

pg_opfamily is a system catalogue table defining operator families.

pg_opfamily was added in PostgreSQL 8.3 (commit a78fcfb5).

Definition by PostgreSQL version

pg_opfamily (PostgreSQL 13)

            Table "pg_catalog.pg_opfamily"
    Column    | Type | Collation | Nullable | Default
--------------+------+-----------+----------+---------
 oid          | oid  |           | not null |
 opfmethod    | oid  |           | not null |
 opfname      | name |           | not null |
 opfnamespace | oid  |           | not null |
 opfowner     | oid  |           | not null |
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 12)

            Table "pg_catalog.pg_opfamily"
    Column    | Type | Collation | Nullable | Default
--------------+------+-----------+----------+---------
 oid          | oid  |           | not null |
 opfmethod    | oid  |           | not null |
 opfname      | name |           | not null |
 opfnamespace | oid  |           | not null |
 opfowner     | oid  |           | not null |
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 11)

            Table "pg_catalog.pg_opfamily"
    Column    | Type | Collation | Nullable | Default
--------------+------+-----------+----------+---------
 opfmethod    | oid  |           | not null |
 opfname      | name |           | not null |
 opfnamespace | oid  |           | not null |
 opfowner     | oid  |           | not null |
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 10)

            Table "pg_catalog.pg_opfamily"
    Column    | Type | Collation | Nullable | Default
--------------+------+-----------+----------+---------
 opfmethod    | oid  |           | not null |
 opfname      | name |           | not null |
 opfnamespace | oid  |           | not null |
 opfowner     | oid  |           | not null |
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.6)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.5)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.4)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.3)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.2)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.1)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 9.0)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 8.4)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 8.3)

 Table "pg_catalog.pg_opfamily"
    Column    | Type | Modifiers
--------------+------+-----------
 opfmethod    | oid  | not null
 opfname      | name | not null
 opfnamespace | oid  | not null
 opfowner     | oid  | not null
Indexes:
    "pg_opfamily_am_name_nsp_index" UNIQUE, btree (opfmethod, opfname, opfnamespace)
    "pg_opfamily_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_opfamily

Change history

This table has not been modified since it was added in PostgreSQL 8.3.

Categories

System catalogue

See also

pg_amop, pg_amproc, pg_opclass