pg_proc
The pg_proc system catalog stores information about functions and procedures. It mimics the pg_proc PostgreSQL system catalog.
Columns
The following columns are available for querying in pg_proc:
| Column | Type | Description |
|---|---|---|
|
|
Object identifier for the function |
|
|
Function name |
|
|
OID of the namespace (schema) containing the function |
|
|
OID of the role that owns the function |
|
|
OID of the implementation language |
|
|
Estimated execution cost (in units of |
|
|
Estimated number of result rows (0 for non-set-returning functions) |
|
|
OID of the data type of the variadic parameter (0 if none) |
|
|
OID of the planner support function (0 if none) |
|
|
Function kind: |
|
|
Whether the function is a security definer |
|
|
Whether the function is leak-proof |
|
|
Whether the function returns NULL if any argument is NULL |
|
|
Whether the function returns a set |
|
|
Volatility category: |
|
|
Parallel safety: |
|
|
Number of input arguments |
|
|
Number of arguments with default values |
|
|
OID of the return data type |
|
|
OIDs of the input argument types (space-separated) |
|
|
OIDs of all argument types including OUT parameters |
|
|
Modes of the arguments: |
|
|
Names of the arguments |
|
|
Expression trees for default argument values |
|
|
OIDs of the types for which to apply transforms |
|
|
Function source code or filename |
|
|
Additional information about how to invoke the function |
|
|
Pre-parsed SQL function body |
|
|
Session configuration variables set when the function is called |
|
|
Access privileges |
