内容

pg_opfamily

定义运算符族的系统表

pg_opfamily 是一个定义运算符族的系统目录表。

pg_opfamily 在PostgreSQL 8.3中添加。

按 PostgreSQL 版本定义

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”的任何评论、建议或更正 此处。