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

0 vote151 views1 answer
Mysql milliseconds
SQL
0 vote152 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote154 views1 answer
Rabbitmq ui not working
SQL
2 votes144 views1 answer
Pandas to sql index
SQL
0 vote142 views1 answer
Java input type sql date
SQL
-1 vote145 views1 answer
Condition in orderby mysql
SQL
0 vote174 views1 answer
Multiple like values for single column postgres
SQL
-2 votes156 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote151 views1 answer
Get the previous column of a table in mysql
SQL
7 votes176 views4 answers
Mysql delete older duplicates
SQL