pg_type

一个存储数据类型信息的系统表

pg_type 是一个系统目录表，用于存储有关数据类型的信息。

pg_type 一直存在于 PostgreSQL 中。

按 PostgreSQL 版本定义

pg_type (PostgreSQL 19)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typsubscript   | regproc      |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" PRIMARY KEY, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE CONSTRAINT, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 18)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typsubscript   | regproc      |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" PRIMARY KEY, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE CONSTRAINT, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 17)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typsubscript   | regproc      |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" PRIMARY KEY, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE CONSTRAINT, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 16)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typsubscript   | regproc      |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" PRIMARY KEY, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE CONSTRAINT, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 15)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typsubscript   | regproc      |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" PRIMARY KEY, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE CONSTRAINT, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 14)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typsubscript   | regproc      |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" PRIMARY KEY, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE CONSTRAINT, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 13)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 12)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 oid            | oid          |           | not null | 
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree | C         |          | 
 typdefault     | text         | C         |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 11)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree |           |          | 
 typdefault     | text         |           |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 10)

                   Table "pg_catalog.pg_type"
     Column     |     Type     | Collation | Nullable | Default 
----------------+--------------+-----------+----------+---------
 typname        | name         |           | not null | 
 typnamespace   | oid          |           | not null | 
 typowner       | oid          |           | not null | 
 typlen         | smallint     |           | not null | 
 typbyval       | boolean      |           | not null | 
 typtype        | "char"       |           | not null | 
 typcategory    | "char"       |           | not null | 
 typispreferred | boolean      |           | not null | 
 typisdefined   | boolean      |           | not null | 
 typdelim       | "char"       |           | not null | 
 typrelid       | oid          |           | not null | 
 typelem        | oid          |           | not null | 
 typarray       | oid          |           | not null | 
 typinput       | regproc      |           | not null | 
 typoutput      | regproc      |           | not null | 
 typreceive     | regproc      |           | not null | 
 typsend        | regproc      |           | not null | 
 typmodin       | regproc      |           | not null | 
 typmodout      | regproc      |           | not null | 
 typanalyze     | regproc      |           | not null | 
 typalign       | "char"       |           | not null | 
 typstorage     | "char"       |           | not null | 
 typnotnull     | boolean      |           | not null | 
 typbasetype    | oid          |           | not null | 
 typtypmod      | integer      |           | not null | 
 typndims       | integer      |           | not null | 
 typcollation   | oid          |           | not null | 
 typdefaultbin  | pg_node_tree |           |          | 
 typdefault     | text         |           |          | 
 typacl         | aclitem[]    |           |          | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.6)

        Table "pg_catalog.pg_type"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 typname        | name         | not null
 typnamespace   | oid          | not null
 typowner       | oid          | not null
 typlen         | smallint     | not null
 typbyval       | boolean      | not null
 typtype        | "char"       | not null
 typcategory    | "char"       | not null
 typispreferred | boolean      | not null
 typisdefined   | boolean      | not null
 typdelim       | "char"       | not null
 typrelid       | oid          | not null
 typelem        | oid          | not null
 typarray       | oid          | not null
 typinput       | regproc      | not null
 typoutput      | regproc      | not null
 typreceive     | regproc      | not null
 typsend        | regproc      | not null
 typmodin       | regproc      | not null
 typmodout      | regproc      | not null
 typanalyze     | regproc      | not null
 typalign       | "char"       | not null
 typstorage     | "char"       | not null
 typnotnull     | boolean      | not null
 typbasetype    | oid          | not null
 typtypmod      | integer      | not null
 typndims       | integer      | not null
 typcollation   | oid          | not null
 typdefaultbin  | pg_node_tree | 
 typdefault     | text         | 
 typacl         | aclitem[]    | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.5)

        Table "pg_catalog.pg_type"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 typname        | name         | not null
 typnamespace   | oid          | not null
 typowner       | oid          | not null
 typlen         | smallint     | not null
 typbyval       | boolean      | not null
 typtype        | "char"       | not null
 typcategory    | "char"       | not null
 typispreferred | boolean      | not null
 typisdefined   | boolean      | not null
 typdelim       | "char"       | not null
 typrelid       | oid          | not null
 typelem        | oid          | not null
 typarray       | oid          | not null
 typinput       | regproc      | not null
 typoutput      | regproc      | not null
 typreceive     | regproc      | not null
 typsend        | regproc      | not null
 typmodin       | regproc      | not null
 typmodout      | regproc      | not null
 typanalyze     | regproc      | not null
 typalign       | "char"       | not null
 typstorage     | "char"       | not null
 typnotnull     | boolean      | not null
 typbasetype    | oid          | not null
 typtypmod      | integer      | not null
 typndims       | integer      | not null
 typcollation   | oid          | not null
 typdefaultbin  | pg_node_tree | 
 typdefault     | text         | 
 typacl         | aclitem[]    | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.4)

        Table "pg_catalog.pg_type"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 typname        | name         | not null
 typnamespace   | oid          | not null
 typowner       | oid          | not null
 typlen         | smallint     | not null
 typbyval       | boolean      | not null
 typtype        | "char"       | not null
 typcategory    | "char"       | not null
 typispreferred | boolean      | not null
 typisdefined   | boolean      | not null
 typdelim       | "char"       | not null
 typrelid       | oid          | not null
 typelem        | oid          | not null
 typarray       | oid          | not null
 typinput       | regproc      | not null
 typoutput      | regproc      | not null
 typreceive     | regproc      | not null
 typsend        | regproc      | not null
 typmodin       | regproc      | not null
 typmodout      | regproc      | not null
 typanalyze     | regproc      | not null
 typalign       | "char"       | not null
 typstorage     | "char"       | not null
 typnotnull     | boolean      | not null
 typbasetype    | oid          | not null
 typtypmod      | integer      | not null
 typndims       | integer      | not null
 typcollation   | oid          | not null
 typdefaultbin  | pg_node_tree | 
 typdefault     | text         | 
 typacl         | aclitem[]    | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.3)

        Table "pg_catalog.pg_type"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 typname        | name         | not null
 typnamespace   | oid          | not null
 typowner       | oid          | not null
 typlen         | smallint     | not null
 typbyval       | boolean      | not null
 typtype        | "char"       | not null
 typcategory    | "char"       | not null
 typispreferred | boolean      | not null
 typisdefined   | boolean      | not null
 typdelim       | "char"       | not null
 typrelid       | oid          | not null
 typelem        | oid          | not null
 typarray       | oid          | not null
 typinput       | regproc      | not null
 typoutput      | regproc      | not null
 typreceive     | regproc      | not null
 typsend        | regproc      | not null
 typmodin       | regproc      | not null
 typmodout      | regproc      | not null
 typanalyze     | regproc      | not null
 typalign       | "char"       | not null
 typstorage     | "char"       | not null
 typnotnull     | boolean      | not null
 typbasetype    | oid          | not null
 typtypmod      | integer      | not null
 typndims       | integer      | not null
 typcollation   | oid          | not null
 typdefaultbin  | pg_node_tree | 
 typdefault     | text         | 
 typacl         | aclitem[]    | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.2)

        Table "pg_catalog.pg_type"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 typname        | name         | not null
 typnamespace   | oid          | not null
 typowner       | oid          | not null
 typlen         | smallint     | not null
 typbyval       | boolean      | not null
 typtype        | "char"       | not null
 typcategory    | "char"       | not null
 typispreferred | boolean      | not null
 typisdefined   | boolean      | not null
 typdelim       | "char"       | not null
 typrelid       | oid          | not null
 typelem        | oid          | not null
 typarray       | oid          | not null
 typinput       | regproc      | not null
 typoutput      | regproc      | not null
 typreceive     | regproc      | not null
 typsend        | regproc      | not null
 typmodin       | regproc      | not null
 typmodout      | regproc      | not null
 typanalyze     | regproc      | not null
 typalign       | "char"       | not null
 typstorage     | "char"       | not null
 typnotnull     | boolean      | not null
 typbasetype    | oid          | not null
 typtypmod      | integer      | not null
 typndims       | integer      | not null
 typcollation   | oid          | not null
 typdefaultbin  | pg_node_tree | 
 typdefault     | text         | 
 typacl         | aclitem[]    | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.1)

        Table "pg_catalog.pg_type"
     Column     |     Type     | Modifiers 
----------------+--------------+-----------
 typname        | name         | not null
 typnamespace   | oid          | not null
 typowner       | oid          | not null
 typlen         | smallint     | not null
 typbyval       | boolean      | not null
 typtype        | "char"       | not null
 typcategory    | "char"       | not null
 typispreferred | boolean      | not null
 typisdefined   | boolean      | not null
 typdelim       | "char"       | not null
 typrelid       | oid          | not null
 typelem        | oid          | not null
 typarray       | oid          | not null
 typinput       | regproc      | not null
 typoutput      | regproc      | not null
 typreceive     | regproc      | not null
 typsend        | regproc      | not null
 typmodin       | regproc      | not null
 typmodout      | regproc      | not null
 typanalyze     | regproc      | not null
 typalign       | "char"       | not null
 typstorage     | "char"       | not null
 typnotnull     | boolean      | not null
 typbasetype    | oid          | not null
 typtypmod      | integer      | not null
 typndims       | integer      | not null
 typcollation   | oid          | not null
 typdefaultbin  | pg_node_tree | 
 typdefault     | text         | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 9.0)

      Table "pg_catalog.pg_type"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 typname        | name     | not null
 typnamespace   | oid      | not null
 typowner       | oid      | not null
 typlen         | smallint | not null
 typbyval       | boolean  | not null
 typtype        | "char"   | not null
 typcategory    | "char"   | not null
 typispreferred | boolean  | not null
 typisdefined   | boolean  | not null
 typdelim       | "char"   | not null
 typrelid       | oid      | not null
 typelem        | oid      | not null
 typarray       | oid      | not null
 typinput       | regproc  | not null
 typoutput      | regproc  | not null
 typreceive     | regproc  | not null
 typsend        | regproc  | not null
 typmodin       | regproc  | not null
 typmodout      | regproc  | not null
 typanalyze     | regproc  | not null
 typalign       | "char"   | not null
 typstorage     | "char"   | not null
 typnotnull     | boolean  | not null
 typbasetype    | oid      | not null
 typtypmod      | integer  | not null
 typndims       | integer  | not null
 typdefaultbin  | text     | 
 typdefault     | text     | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 8.4)

      Table "pg_catalog.pg_type"
     Column     |   Type   | Modifiers 
----------------+----------+-----------
 typname        | name     | not null
 typnamespace   | oid      | not null
 typowner       | oid      | not null
 typlen         | smallint | not null
 typbyval       | boolean  | not null
 typtype        | "char"   | not null
 typcategory    | "char"   | not null
 typispreferred | boolean  | not null
 typisdefined   | boolean  | not null
 typdelim       | "char"   | not null
 typrelid       | oid      | not null
 typelem        | oid      | not null
 typarray       | oid      | not null
 typinput       | regproc  | not null
 typoutput      | regproc  | not null
 typreceive     | regproc  | not null
 typsend        | regproc  | not null
 typmodin       | regproc  | not null
 typmodout      | regproc  | not null
 typanalyze     | regproc  | not null
 typalign       | "char"   | not null
 typstorage     | "char"   | not null
 typnotnull     | boolean  | not null
 typbasetype    | oid      | not null
 typtypmod      | integer  | not null
 typndims       | integer  | not null
 typdefaultbin  | text     | 
 typdefault     | text     | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 8.3)

      Table "pg_catalog.pg_type"
    Column     |   Type   | Modifiers 
---------------+----------+-----------
 typname       | name     | not null
 typnamespace  | oid      | not null
 typowner      | oid      | not null
 typlen        | smallint | not null
 typbyval      | boolean  | not null
 typtype       | "char"   | not null
 typisdefined  | boolean  | not null
 typdelim      | "char"   | not null
 typrelid      | oid      | not null
 typelem       | oid      | not null
 typarray      | oid      | not null
 typinput      | regproc  | not null
 typoutput     | regproc  | not null
 typreceive    | regproc  | not null
 typsend       | regproc  | not null
 typmodin      | regproc  | not null
 typmodout     | regproc  | not null
 typanalyze    | regproc  | not null
 typalign      | "char"   | not null
 typstorage    | "char"   | not null
 typnotnull    | boolean  | not null
 typbasetype   | oid      | not null
 typtypmod     | integer  | not null
 typndims      | integer  | not null
 typdefaultbin | text     | 
 typdefault    | text     | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

pg_type (PostgreSQL 8.2)

      Table "pg_catalog.pg_type"
    Column     |   Type   | Modifiers 
---------------+----------+-----------
 typname       | name     | not null
 typnamespace  | oid      | not null
 typowner      | oid      | not null
 typlen        | smallint | not null
 typbyval      | boolean  | not null
 typtype       | "char"   | not null
 typisdefined  | boolean  | not null
 typdelim      | "char"   | not null
 typrelid      | oid      | not null
 typelem       | oid      | not null
 typinput      | regproc  | not null
 typoutput     | regproc  | not null
 typreceive    | regproc  | not null
 typsend       | regproc  | not null
 typanalyze    | regproc  | not null
 typalign      | "char"   | not null
 typstorage    | "char"   | not null
 typnotnull    | boolean  | not null
 typbasetype   | oid      | not null
 typtypmod     | integer  | not null
 typndims      | integer  | not null
 typdefaultbin | text     | 
 typdefault    | text     | 
Indexes:
    "pg_type_oid_index" UNIQUE, btree (oid)
    "pg_type_typname_nsp_index" UNIQUE, btree (typname, typnamespace)

文档： pg_type

变更历史

进行中

PostgreSQL 14
- 添加了列 typsubscript (commit c7aba7c1)
- 列 typtype 可以包含值 m 来表示多范围类型 (commit 6df7a969)
PostgreSQL 9.1
- 添加了列 typcollation (commit 414c5a2e)
PostgreSQL 8.4
- 添加了列 typcategory 和 typispreferred (commit bac3e836)
PostgreSQL 8.3
- 列 typtype 可以包含值 e 来表示 ENUM (commit 57690c68)
- 添加了列 typmodin 和 typmodout (commit 5725b9d9)
PostgreSQL 8.0
- 添加了列 typanalyze (commit 69946411)
PostgreSQL 7.4
- 重新添加了以下列 (commit 45d04099)
  - typreceive
  - typsend
PostgreSQL 7.3
- 删除了以下列 (commit 739adf32)
  - typprtlen
  - typreceive
  - typsend

源代码

在 PostgreSQL 8.4 (commit 039dfbfd) 和 PostgreSQL 11 (commit cefa3871) 之间，存在一个额外的源文件 src/include/catalog/pg_type_fn.h，用于使目录定义能够被前端代码包含。

参考资料

PostgreSQL 文档： pg_type

另请参阅

pg_range

反馈

在此处提交关于 "pg_type" 的任何评论、建议或更正 这里。

版本图表

实用概述

有用链接

咖啡

目录

pg_type

按 PostgreSQL 版本定义

pg_type (PostgreSQL 19)

pg_type (PostgreSQL 18)

pg_type (PostgreSQL 17)

pg_type (PostgreSQL 16)

pg_type (PostgreSQL 15)

pg_type (PostgreSQL 14)

pg_type (PostgreSQL 13)

pg_type (PostgreSQL 12)

pg_type (PostgreSQL 11)

pg_type (PostgreSQL 10)

pg_type (PostgreSQL 9.6)

pg_type (PostgreSQL 9.5)

pg_type (PostgreSQL 9.4)

pg_type (PostgreSQL 9.3)

pg_type (PostgreSQL 9.2)

pg_type (PostgreSQL 9.1)

pg_type (PostgreSQL 9.0)

pg_type (PostgreSQL 8.4)

pg_type (PostgreSQL 8.3)

pg_type (PostgreSQL 8.2)

变更历史

源代码

参考资料

分类

另请参阅

反馈