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 vote204 views1 answer
Xampp increame mysql speed
SQL
2 votes206 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote218 views1 answer
Mysql a from on this page has
SQL
6 votes206 views4 answers
Remove spaces sql server
SQL
104 votes321 views2 answers
Like in mysql
SQL
1 vote201 views1 answer
Mysql not supported auth mode
SQL
7 votes218 views1 answer
Buy forge mods server hosting
SQL
1 vote209 views1 answer
Postgres install unaccent extension
SQL
4 votes209 views4 answers
Oracle tablespace tables list
SQL
0 vote205 views1 answer
Mysql check datetime equals date
SQL