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 vote289 views1 answer
Get from database the most recent data limit by 5
SQL
3 votes311 views3 answers
Postgresql random number
SQL
0 vote267 views1 answer
Clone table structure mysql
SQL
0 vote282 views1 answer
Get the Db column names from a SqlDataReader
SQL
3 votes310 views1 answer
Sql print all names that start with a given letter
SQL
0 vote272 views1 answer
Mysql command prompt date insert format
SQL
0 vote279 views1 answer
Sql string contains case sensitive
SQL
5 votes271 views2 answers
Update all rows mysql
SQL
56 votes537 views5 answers
Psql create user
SQL
8 votes304 views2 answers
Oracle undo usage
SQL