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 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