SHOW FUNCTIONS
Run SHOW FUNCTIONS to get a list of existing user-defined functions. The returned information includes the name, argument types, return type, language, and server address of each function.
Syntax
SHOW FUNCTIONS [ LIKE_expression ];
Parameters
| Parameter or clause | Description |
|---|---|
| LIKE_expression | Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions. |
Example
Name | Arguments | Return Type | Language | Link
------------------+---------------------------+---------------------------------------------------------------------------+----------+-----------------------
jsonb_concat | jsonb[] | jsonb | python | http://localhost:8815
array_access | varchar[], integer | varchar | python | http://localhost:8815
hex_to_dec | varchar | numeric | python | http://localhost:8815
gcd | integer, integer, integer | integer | python | http://localhost:8815
gcd | integer, integer | integer | python | http://localhost:8815
extract_tcp_info | bytea | struct<src_ip varchar,dst_ip varchar,src_port smallint,dst_port smallint> | python | http://localhost:8815
int_42 | | integer | python | http://localhost:8815
series2 | integer | struct<x integer,y varchar> | python | http://localhost:8815
series | integer | integer | python | http://localhost:8815
jsonb_access | jsonb, integer | jsonb | python | http://localhost:8815
(10 rows)