Sp help text in postgresql

SELECT n.nspname AS schema
      ,proname AS fname
      ,proargnames AS args
      ,t.typname AS return_type
      ,d.description
      ,pg_get_functiondef(p.oid) as definition
--      ,CASE WHEN NOT p.proisagg THEN pg_get_functiondef(p.oid)
--            ELSE 'pg_get_functiondef() can''t be used with aggregate functions'
--       END as definition
  FROM pg_proc p
  JOIN pg_type t
    ON p.prorettype = t.oid
  LEFT OUTER
  JOIN pg_description d
    ON p.oid = d.objoid
  LEFT OUTER
  JOIN pg_namespace n
    ON n.oid = p.pronamespace
 WHERE NOT p.proisagg
   AND n.nspname~'<$SCHEMA_NAME_PATTERN>'
   AND proname~'<$FUNCTION_NAME_PATTERN>'

Source: stackoverflow.com

Similar codes

21 votes377 views3 answers
Sql server search column name in all tables
SQL
0 vote423 views3 answers
Postgres trim string
SQL
0 vote329 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
2 votes345 views1 answer
Anonymous block plsql
SQL
0 vote347 views1 answer
Mysql set boolean default value
SQL
2 votes367 views1 answer
How to get non distinct values in sql
SQL
0 vote386 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote376 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
7 votes338 views1 answer
Query delete duplicates
SQL
1 vote385 views1 answer
Epoch time converter in snowflake
SQL