SHOW FUNCTIONS#
Synopsis#
SHOW FUNCTIONS [ FROM schema ] [ LIKE pattern ]
Description#
List functions in schema
or all functions in the current session path.
For each function returned, the following information is displayed:
Function name
Return type
Argument types
Function type
Deterministic
Description
Specify a pattern in the optional LIKE
clause to
filter the results to the desired subset. For example, the following query
allows you to find functions beginning with array
:
SHOW FUNCTIONS LIKE 'array%';
SHOW FUNCTIONS
works with built-in functions as well as with custom functions.
In the following example, three custom functions beginning with cf
are
available:
SHOW FUNCTIONS LIKE 'cf%';
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