View pg_functions

Creates a view to get all functions of the current database, excluding those in the schema pg_catalog and information_schema.

Columns

Column Name	datatype	Description
schema_name	name	The name of the schema where the function is stored in.
function_name	name	The name of the function or procedure.
returning_data_type	text	The data type that the function is returning.
parameters	text	Parameters used to call the function.
function_type	text	The type of function, can be aggregate, window, function, trigger, or unknown.
function_comment	text	The comment, that is added to descrbe the function.

Example

SELECT *
FROM pg_functions;

schema_name	function_name	returning_data_type	parameters	function_type	function_comment
public	date_de	character varying	d date	function	Creates a function which returns the given date in German format
public	datetime_de	character varying	t timestamp without time zone	function	Creates a function which returns the given timestamp in German format