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 vote324 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote382 views2 answers
Remove mysql workbench ubuntu
SQL
2 votes319 views1 answer
Oracle current date without time
SQL
0 vote351 views1 answer
How to install sql in anaconda
SQL
4 votes349 views1 answer
Oracle nls_date_format
SQL
0 vote321 views1 answer
Mysql docker image arjun
SQL
0 vote382 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote336 views1 answer
Ms sql filter all sympbol
SQL
1 vote306 views2 answers
T-sql random number for each row
SQL
1 vote360 views1 answer
Backup mysql schema only
SQL