SHOW FUNCTIONS
Synopsis
SHOW FUNCTIONS [ FROM schema ] [ LIKE pattern ]
Description
List functions in schema or all functions in the current session path. This
can include built-in functions, functions from a custom
plugin, and User-defined functions.
For each function returned, the following information is displayed:
- Function name
- Return type
- Argument types
- Function type
- Deterministic
- Description
Use the optional FROM keyword to only list functions in a specific catalog and
schema. The location in schema must be specified as
cataglog_name.schema_name.
Specify a pattern in the optional LIKE clause to
filter the results to the desired subset.
Examples
List all UDFs and plugin functions in the default schema of the example
catalog:
SHOW FUNCTIONS FROM example.default;
List all functions with a name beginning with array:
SHOW FUNCTIONS LIKE 'array%';
List all functions with a name beginning with cf:
SHOW FUNCTIONS LIKE 'cf%';
Example output:
Function | Return Type | Argument Types | Function Type | Deterministic | Description
------------------+-------------+----------------+---------------+---------------+-----------------------------------------
cf_getgroups | varchar | | scalar | true | Returns the current session's groups
cf_getprincipal | varchar | | scalar | true | Returns the current session's principal
cf_getuser | varchar | | scalar | true | Returns the current session's user