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

7 votes148 views4 answers
Database dump mysql command
SQL
0 vote136 views1 answer
Generate sequence number in sql server
SQL
0 vote97 views1 answer
Expose db in virtualbox
SQL
0 vote118 views1 answer
Insert thai language sql server
SQL
0 vote138 views1 answer
Exectuer myssql .sql
SQL
1 vote131 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote135 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote130 views1 answer
Sql server port 1434
SQL
0 vote156 views1 answer
Sql server information_schema temp tables
SQL
17 votes158 views1 answer
Selecting name that contain certain word in sql
SQL