目录

pg_opfamily

定义操作符族的系统表

pg_opfamily 是一个定义操作符族的 系统目录 表。

pg_opfamily 在 PostgreSQL 8.3 中被添加。

按 PostgreSQL 版本定义

pg_opfamily (PostgreSQL 19)

            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)

文档: pg_opfamily

pg_opfamily (PostgreSQL 18)

            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)

文档: pg_opfamily

pg_opfamily (PostgreSQL 17)

            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)

文档: pg_opfamily

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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: pg_opfamily

变更历史

自 PostgreSQL 8.3 添加以来，此表未被修改。

分类

系统目录

另请参阅

pg_amop, pg_amproc, pg_opclass, CREATE OPERATOR FAMILY, pg_opfamily_is_visible()

反馈

请在此处提交有关“pg_opfamily”的任何评论、建议或更正 here。