Skip to main content

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 clauseDescription
LIKE_expressionFilters 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)

Help us make this doc better!