pg_proc

一个存储关于函数、过程、聚合函数和窗口函数信息的系统表

pg_proc 是一个系统目录表，它存储关于函数、过程（自 PostgreSQL 11 起）、聚合函数和窗口函数的信息。

pg_proc 一直存在于 PostgreSQL 中。

源代码

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

按 PostgreSQL 版本定义

pg_proc (PostgreSQL 19)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 prosqlbody      | pg_node_tree | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" PRIMARY KEY, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE CONSTRAINT, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 18)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 prosqlbody      | pg_node_tree | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" PRIMARY KEY, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE CONSTRAINT, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 17)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 prosqlbody      | pg_node_tree | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" PRIMARY KEY, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE CONSTRAINT, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 16)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 prosqlbody      | pg_node_tree | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" PRIMARY KEY, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE CONSTRAINT, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 15)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 prosqlbody      | pg_node_tree | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" PRIMARY KEY, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE CONSTRAINT, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 14)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 prosqlbody      | pg_node_tree | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" PRIMARY KEY, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE CONSTRAINT, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 13)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 12)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 oid             | oid          |           | not null | 
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 prosupport      | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       | C         |          | 
 proargdefaults  | pg_node_tree | C         |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         | C         | not null | 
 probin          | text         | C         |          | 
 proconfig       | text[]       | C         |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 11)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 protransform    | regproc      |           | not null | 
 prokind         | "char"       |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       |           |          | 
 proargdefaults  | pg_node_tree |           |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         |           | not null | 
 probin          | text         |           |          | 
 proconfig       | text[]       |           |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 10)

                   Table "pg_catalog.pg_proc"
     Column      |     Type     | Collation | Nullable | Default 
-----------------+--------------+-----------+----------+---------
 proname         | name         |           | not null | 
 pronamespace    | oid          |           | not null | 
 proowner        | oid          |           | not null | 
 prolang         | oid          |           | not null | 
 procost         | real         |           | not null | 
 prorows         | real         |           | not null | 
 provariadic     | oid          |           | not null | 
 protransform    | regproc      |           | not null | 
 proisagg        | boolean      |           | not null | 
 proiswindow     | boolean      |           | not null | 
 prosecdef       | boolean      |           | not null | 
 proleakproof    | boolean      |           | not null | 
 proisstrict     | boolean      |           | not null | 
 proretset       | boolean      |           | not null | 
 provolatile     | "char"       |           | not null | 
 proparallel     | "char"       |           | not null | 
 pronargs        | smallint     |           | not null | 
 pronargdefaults | smallint     |           | not null | 
 prorettype      | oid          |           | not null | 
 proargtypes     | oidvector    |           | not null | 
 proallargtypes  | oid[]        |           |          | 
 proargmodes     | "char"[]     |           |          | 
 proargnames     | text[]       |           |          | 
 proargdefaults  | pg_node_tree |           |          | 
 protrftypes     | oid[]        |           |          | 
 prosrc          | text         |           | not null | 
 probin          | text         |           |          | 
 proconfig       | text[]       |           |          | 
 proacl          | aclitem[]    |           |          | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.6)

         Table "pg_catalog.pg_proc"
     Column      |     Type     | Modifiers 
-----------------+--------------+-----------
 proname         | name         | not null
 pronamespace    | oid          | not null
 proowner        | oid          | not null
 prolang         | oid          | not null
 procost         | real         | not null
 prorows         | real         | not null
 provariadic     | oid          | not null
 protransform    | regproc      | not null
 proisagg        | boolean      | not null
 proiswindow     | boolean      | not null
 prosecdef       | boolean      | not null
 proleakproof    | boolean      | not null
 proisstrict     | boolean      | not null
 proretset       | boolean      | not null
 provolatile     | "char"       | not null
 proparallel     | "char"       | not null
 pronargs        | smallint     | not null
 pronargdefaults | smallint     | not null
 prorettype      | oid          | not null
 proargtypes     | oidvector    | not null
 proallargtypes  | oid[]        | 
 proargmodes     | "char"[]     | 
 proargnames     | text[]       | 
 proargdefaults  | pg_node_tree | 
 protrftypes     | oid[]        | 
 prosrc          | text         | not null
 probin          | text         | 
 proconfig       | text[]       | 
 proacl          | aclitem[]    | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.5)

         Table "pg_catalog.pg_proc"
     Column      |     Type     | Modifiers 
-----------------+--------------+-----------
 proname         | name         | not null
 pronamespace    | oid          | not null
 proowner        | oid          | not null
 prolang         | oid          | not null
 procost         | real         | not null
 prorows         | real         | not null
 provariadic     | oid          | not null
 protransform    | regproc      | not null
 proisagg        | boolean      | not null
 proiswindow     | boolean      | not null
 prosecdef       | boolean      | not null
 proleakproof    | boolean      | not null
 proisstrict     | boolean      | not null
 proretset       | boolean      | not null
 provolatile     | "char"       | not null
 pronargs        | smallint     | not null
 pronargdefaults | smallint     | not null
 prorettype      | oid          | not null
 proargtypes     | oidvector    | not null
 proallargtypes  | oid[]        | 
 proargmodes     | "char"[]     | 
 proargnames     | text[]       | 
 proargdefaults  | pg_node_tree | 
 protrftypes     | oid[]        | 
 prosrc          | text         | not null
 probin          | text         | 
 proconfig       | text[]       | 
 proacl          | aclitem[]    | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.4)

         Table "pg_catalog.pg_proc"
     Column      |     Type     | Modifiers 
-----------------+--------------+-----------
 proname         | name         | not null
 pronamespace    | oid          | not null
 proowner        | oid          | not null
 prolang         | oid          | not null
 procost         | real         | not null
 prorows         | real         | not null
 provariadic     | oid          | not null
 protransform    | regproc      | not null
 proisagg        | boolean      | not null
 proiswindow     | boolean      | not null
 prosecdef       | boolean      | not null
 proleakproof    | boolean      | not null
 proisstrict     | boolean      | not null
 proretset       | boolean      | not null
 provolatile     | "char"       | not null
 pronargs        | smallint     | not null
 pronargdefaults | smallint     | not null
 prorettype      | oid          | not null
 proargtypes     | oidvector    | not null
 proallargtypes  | oid[]        | 
 proargmodes     | "char"[]     | 
 proargnames     | text[]       | 
 proargdefaults  | pg_node_tree | 
 prosrc          | text         | 
 probin          | text         | 
 proconfig       | text[]       | 
 proacl          | aclitem[]    | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.3)

         Table "pg_catalog.pg_proc"
     Column      |     Type     | Modifiers 
-----------------+--------------+-----------
 proname         | name         | not null
 pronamespace    | oid          | not null
 proowner        | oid          | not null
 prolang         | oid          | not null
 procost         | real         | not null
 prorows         | real         | not null
 provariadic     | oid          | not null
 protransform    | regproc      | not null
 proisagg        | boolean      | not null
 proiswindow     | boolean      | not null
 prosecdef       | boolean      | not null
 proleakproof    | boolean      | not null
 proisstrict     | boolean      | not null
 proretset       | boolean      | not null
 provolatile     | "char"       | not null
 pronargs        | smallint     | not null
 pronargdefaults | smallint     | not null
 prorettype      | oid          | not null
 proargtypes     | oidvector    | not null
 proallargtypes  | oid[]        | 
 proargmodes     | "char"[]     | 
 proargnames     | text[]       | 
 proargdefaults  | pg_node_tree | 
 prosrc          | text         | 
 probin          | text         | 
 proconfig       | text[]       | 
 proacl          | aclitem[]    | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.2)

         Table "pg_catalog.pg_proc"
     Column      |     Type     | Modifiers 
-----------------+--------------+-----------
 proname         | name         | not null
 pronamespace    | oid          | not null
 proowner        | oid          | not null
 prolang         | oid          | not null
 procost         | real         | not null
 prorows         | real         | not null
 provariadic     | oid          | not null
 protransform    | regproc      | not null
 proisagg        | boolean      | not null
 proiswindow     | boolean      | not null
 prosecdef       | boolean      | not null
 proleakproof    | boolean      | not null
 proisstrict     | boolean      | not null
 proretset       | boolean      | not null
 provolatile     | "char"       | not null
 pronargs        | smallint     | not null
 pronargdefaults | smallint     | not null
 prorettype      | oid          | not null
 proargtypes     | oidvector    | not null
 proallargtypes  | oid[]        | 
 proargmodes     | "char"[]     | 
 proargnames     | text[]       | 
 proargdefaults  | pg_node_tree | 
 prosrc          | text         | 
 probin          | text         | 
 proconfig       | text[]       | 
 proacl          | aclitem[]    | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.1)

         Table "pg_catalog.pg_proc"
     Column      |     Type     | Modifiers 
-----------------+--------------+-----------
 proname         | name         | not null
 pronamespace    | oid          | not null
 proowner        | oid          | not null
 prolang         | oid          | not null
 procost         | real         | not null
 prorows         | real         | not null
 provariadic     | oid          | not null
 proisagg        | boolean      | not null
 proiswindow     | boolean      | not null
 prosecdef       | boolean      | not null
 proisstrict     | boolean      | not null
 proretset       | boolean      | not null
 provolatile     | "char"       | not null
 pronargs        | smallint     | not null
 pronargdefaults | smallint     | not null
 prorettype      | oid          | not null
 proargtypes     | oidvector    | not null
 proallargtypes  | oid[]        | 
 proargmodes     | "char"[]     | 
 proargnames     | text[]       | 
 proargdefaults  | pg_node_tree | 
 prosrc          | text         | 
 probin          | text         | 
 proconfig       | text[]       | 
 proacl          | aclitem[]    | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 9.0)

       Table "pg_catalog.pg_proc"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 proname         | name      | not null
 pronamespace    | oid       | not null
 proowner        | oid       | not null
 prolang         | oid       | not null
 procost         | real      | not null
 prorows         | real      | not null
 provariadic     | oid       | not null
 proisagg        | boolean   | not null
 proiswindow     | boolean   | not null
 prosecdef       | boolean   | not null
 proisstrict     | boolean   | not null
 proretset       | boolean   | not null
 provolatile     | "char"    | not null
 pronargs        | smallint  | not null
 pronargdefaults | smallint  | not null
 prorettype      | oid       | not null
 proargtypes     | oidvector | not null
 proallargtypes  | oid[]     | 
 proargmodes     | "char"[]  | 
 proargnames     | text[]    | 
 proargdefaults  | text      | 
 prosrc          | text      | 
 probin          | text      | 
 proconfig       | text[]    | 
 proacl          | aclitem[] | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 8.4)

       Table "pg_catalog.pg_proc"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 proname         | name      | not null
 pronamespace    | oid       | not null
 proowner        | oid       | not null
 prolang         | oid       | not null
 procost         | real      | not null
 prorows         | real      | not null
 provariadic     | oid       | not null
 proisagg        | boolean   | not null
 proiswindow     | boolean   | not null
 prosecdef       | boolean   | not null
 proisstrict     | boolean   | not null
 proretset       | boolean   | not null
 provolatile     | "char"    | not null
 pronargs        | smallint  | not null
 pronargdefaults | smallint  | not null
 prorettype      | oid       | not null
 proargtypes     | oidvector | not null
 proallargtypes  | oid[]     | 
 proargmodes     | "char"[]  | 
 proargnames     | text[]    | 
 proargdefaults  | text      | 
 prosrc          | text      | 
 probin          | bytea     | 
 proconfig       | text[]    | 
 proacl          | aclitem[] | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 8.3)

       Table "pg_catalog.pg_proc"
     Column     |   Type    | Modifiers 
----------------+-----------+-----------
 proname        | name      | not null
 pronamespace   | oid       | not null
 proowner       | oid       | not null
 prolang        | oid       | not null
 procost        | real      | not null
 prorows        | real      | not null
 proisagg       | boolean   | not null
 prosecdef      | boolean   | not null
 proisstrict    | boolean   | not null
 proretset      | boolean   | not null
 provolatile    | "char"    | not null
 pronargs       | smallint  | not null
 prorettype     | oid       | not null
 proargtypes    | oidvector | not null
 proallargtypes | oid[]     | 
 proargmodes    | "char"[]  | 
 proargnames    | text[]    | 
 prosrc         | text      | 
 probin         | bytea     | 
 proconfig      | text[]    | 
 proacl         | aclitem[] | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

pg_proc (PostgreSQL 8.2)

       Table "pg_catalog.pg_proc"
     Column     |   Type    | Modifiers 
----------------+-----------+-----------
 proname        | name      | not null
 pronamespace   | oid       | not null
 proowner       | oid       | not null
 prolang        | oid       | not null
 proisagg       | boolean   | not null
 prosecdef      | boolean   | not null
 proisstrict    | boolean   | not null
 proretset      | boolean   | not null
 provolatile    | "char"    | not null
 pronargs       | smallint  | not null
 prorettype     | oid       | not null
 proargtypes    | oidvector | not null
 proallargtypes | oid[]     | 
 proargmodes    | "char"[]  | 
 proargnames    | text[]    | 
 prosrc         | text      | 
 probin         | bytea     | 
 proacl         | aclitem[] | 
Indexes:
    "pg_proc_oid_index" UNIQUE, btree (oid)
    "pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)

文档: pg_proc

变更历史

注意：在此之前的 PostgreSQL 8.2 版本可能未显示所有更改。

PostgreSQL 14
- 添加了 prosqlbody 列 (commit e717a9a1)
PostgreSQL 12
- protransform 列重命名为 prosupport (commit 74dfe58a)
PostgreSQL 11
- proisagg 和 proiswindow 列被 prokind 替换 (commit fd1a421f)
PostgreSQL 9.6
- 添加了 proparallel 列 (commit 7aea8e4f)
PostgreSQL 9.5
- 添加了 protrftypes 列 (commit cac76582)
PostgreSQL 9.2
- 添加了 protransform 列 (commit 8f9fe6ed)
- 添加了 proleakproof 列 (commit cd30728f)
PostgreSQL 9.1
- proargdefaults 列类型更改为 pg_node_tree (commit 303696c3)
PostgreSQL 8.4
- 添加了 procost 列 (commit 5a7471c3)
- 添加了 prorows 列 (commit 5a7471c3)
- 添加了 provariadic 列 (commit 6563e9e2)
PostgreSQL 8.3
- 添加了 procost 列 (commit 5a7471c3)
- 添加了 prorows 列 (commit 5a7471c3)
- 添加了 proconfig 列 (commit 2abae34a)
PostgreSQL 7.3
- 移除了以下列 (commit 739adf32)
  - proimplicit
  - probyte_pct
  - properbyte_cpu
  - propercall_cpu
  - prooutin_ratio

参考资料

PostgreSQL 文档: pg_proc

反馈

请在此处提交有关 "pg_proc" 的任何评论、建议或更正 。

版本图表

实用概述

有用链接

咖啡

目录

pg_proc

源代码

按 PostgreSQL 版本定义

pg_proc (PostgreSQL 19)

pg_proc (PostgreSQL 18)

pg_proc (PostgreSQL 17)

pg_proc (PostgreSQL 16)

pg_proc (PostgreSQL 15)

pg_proc (PostgreSQL 14)

pg_proc (PostgreSQL 13)

pg_proc (PostgreSQL 12)

pg_proc (PostgreSQL 11)

pg_proc (PostgreSQL 10)

pg_proc (PostgreSQL 9.6)

pg_proc (PostgreSQL 9.5)

pg_proc (PostgreSQL 9.4)

pg_proc (PostgreSQL 9.3)

pg_proc (PostgreSQL 9.2)

pg_proc (PostgreSQL 9.1)

pg_proc (PostgreSQL 9.0)

pg_proc (PostgreSQL 8.4)

pg_proc (PostgreSQL 8.3)

pg_proc (PostgreSQL 8.2)

变更历史

参考资料

分类

反馈