pg_opfamily

A system table defining operator families

pg_opfamily is a system catalogue table defining operator families.

pg_opfamily was added in PostgreSQL 8.3.

Definition by PostgreSQL version

pg_opfamily (PostgreSQL 16)

            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_oid_index" PRIMARY KEY, btree (oid)
    "pg_opfamily_am_name_nsp_index" UNIQUE CONSTRAINT, btree (opfmethod, opfname, opfnamespace)

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 15)

            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_oid_index" PRIMARY KEY, btree (oid)
    "pg_opfamily_am_name_nsp_index" UNIQUE CONSTRAINT, btree (opfmethod, opfname, opfnamespace)

Documentation: pg_opfamily

pg_opfamily (PostgreSQL 14)

            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_oid_index" PRIMARY KEY, btree (oid)
    "pg_opfamily_am_name_nsp_index" UNIQUE CONSTRAINT, btree (opfmethod, opfname, opfnamespace)

Documentation: pg_opfamily

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.

PostgreSQL 8.3
- added (commit a78fcfb5)

References

PostgreSQL documentation: pg_opfamily

Version charts

Useful overviews

Useful links

Contents

pg_opfamily

Definition by PostgreSQL version

pg_opfamily (PostgreSQL 16)

pg_opfamily (PostgreSQL 15)

pg_opfamily (PostgreSQL 14)

pg_opfamily (PostgreSQL 13)

pg_opfamily (PostgreSQL 12)

pg_opfamily (PostgreSQL 11)

pg_opfamily (PostgreSQL 10)

pg_opfamily (PostgreSQL 9.6)

pg_opfamily (PostgreSQL 9.5)

pg_opfamily (PostgreSQL 9.4)

pg_opfamily (PostgreSQL 9.3)

pg_opfamily (PostgreSQL 9.2)

pg_opfamily (PostgreSQL 9.1)

pg_opfamily (PostgreSQL 9.0)

pg_opfamily (PostgreSQL 8.4)

pg_opfamily (PostgreSQL 8.3)

Change history

References

Categories

See also