Syntax
SHOW FUNCTIONS [ FROM schema_name ] [ LIKE_expression ];
Parameters
| Parameter or clause | Description |
|---|---|
| schema_name | The schema of the functions to be listed. If not specified, functions from all schemas in the current schema search_path will be listed. |
| 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
-------------------------+---------------------------+---------------------------------------------------------------------------+----------+-------------------------
public.jsonb_concat | jsonb[] | jsonb | python | http://localhost:8815
public.array_access | varchar[], integer | varchar | python | http://localhost:8815
public.hex_to_dec | varchar | numeric | python | http://localhost:8815
public.gcd | integer, integer, integer | integer | python | http://localhost:8815
public.gcd | integer, integer | integer | python | http://localhost:8815
public.extract_tcp_info | bytea | struct<src_ip varchar,dst_ip varchar,src_port smallint,dst_port smallint> | python | http://localhost:8815
public.int_42 | | integer | python | http://localhost:8815
public.series2 | integer | struct<x integer,y varchar> | python | http://localhost:8815
public.series | integer | integer | python | http://localhost:8815
public.jsonb_access | jsonb, integer | jsonb | python | http://localhost:8815
(10 rows)
Starting from v2.7.0, the
Name column in the output includes the schema name as a prefix (e.g., public.function_name). This helps distinguish functions with the same name in different schemas when querying across multiple schemas in the search path.