SQL reference
- Overview
- Commands
- Overview
- ALTER CONNECTION
- ALTER DATABASE
- ALTER FUNCTION
- ALTER INDEX
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER SINK
- ALTER SOURCE
- ALTER SYSTEM
- ALTER TABLE
- ALTER USER
- ALTER VIEW
- AS CHANGELOG
- BEGIN
- CANCEL JOBS
- COMMENT ON
- COMMIT
- CREATE AGGREGATE
- CREATE CONNECTION
- CREATE DATABASE
- CREATE FUNCTION
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE SCHEMA
- CREATE SECRET
- CREATE SINK INTO
- CREATE SINK
- CREATE SOURCE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DELETE
- DESCRIBE
- DISCARD
- DROP AGGREGATE
- DROP CONNECTION
- DROP DATABASE
- DROP FUNCTION
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP SCHEMA
- DROP SECRET
- DROP SINK
- DROP SOURCE
- DROP TABLE
- DROP USER
- DROP VIEW
- EXPLAIN
- FLUSH
- GRANT
- INSERT
- RECOVER
- REVOKE
- SELECT
- SET BACKGROUND_DDL
- SET RW_IMPLICIT_FLUSH
- SET TIME ZONE
- SET
- SHOW CLUSTER
- SHOW COLUMNS
- SHOW CONNECTIONS
- SHOW CREATE INDEX
- SHOW CREATE MATERIALIZED VIEW
- SHOW CREATE SINK
- SHOW CREATE SOURCE
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW CURSORS
- SHOW DATABASES
- SHOW FUNCTIONS
- SHOW INDEXES
- SHOW INTERNAL TABLES
- SHOW JOBS
- SHOW MATERIALIZED VIEWS
- SHOW PARAMETERS
- SHOW PROCESSLIST
- SHOW SCHEMAS
- SHOW SINKS
- SHOW SOURCES
- SHOW SUBSCRIPTION CURSORS
- SHOW TABLES
- SHOW VIEWS
- START TRANSACTION
- UPDATE
- Query syntax
- Data types
- Functions and operators
- Identifiers
- System catalogs
- Psql commands
Commands
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)
Was this page helpful?
On this page