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

1 vote187 views1 answer
Sql drop schema
SQL
0 vote193 views2 answers
Sql having multiple conditions
SQL
23 votes165 views6 answers
Create table sql
SQL
0 vote199 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote189 views3 answers
SELECT * FROM
SQL
0 vote169 views1 answer
Add column not null with default value postgres
SQL
3 votes214 views1 answer
Oracle list invalid password logon denied
SQL
0 vote172 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
7 votes171 views2 answers
Show size database mysql
SQL
10 votes173 views2 answers
Reset mysql root password mac
SQL