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 SQL routines.
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 SQL routines 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