This page provides information about the functions in the database.
Very large numbers of system functions are present in the schema
pg_catalog, and so the default behaviour (on all pages, in
fact) is to exclude that schema (and one or two others), so you see only
user defined functions.
All, or very nearly almost all, of the system provided functions have no text stored in the system tables. I have no idea why, but there it is. It might be a property of Redshift, rather than Postgres, but I’ve not looked (Redshift also does not allow users to access the system columnds in each table, where Postgres does).
| Name | Type |
|---|---|
| schema_id | int8 |
| schema | varchar |
| language_id | int8 |
| language | varchar |
| owner_user_id | int4 |
| owner | varchar |
| volatility | varchar |
| return | varchar |
| function_id | int8 |
| function | varchar |
| arguments_ids | varchar |
| arguments | varchar |
| related pages | varchar |
The schema ID. This column is emitted in CSV exports only.
The schema name.
The language ID. This column is emitted in CSV exports only.
The language name.
The owner user ID. This column is emitted in CSV exports only.
The owner user name.
One of three values, indicating function volatility;
| Value |
|---|
| immutable |
| stable |
| volatile |
Nice that the logical ordering of the values is also alphabetic :-)
The data type of the return value of the function.
The function ID. This column is emitted in CSV exports only.
The function name.
A comma separated string of the data type IDs for the function arguments. This column is emitted in CSV exports only.
A comma separated string of the base (so not adorned with lengths, precision, scale, etc) data type names for the function arguments.