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 vote305 views2 answers
How to generate a unique random number in mysql
SQL
10 votes332 views2 answers
Mysql drop database if exists
SQL
7 votes273 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
1 vote299 views1 answer
Last 6 months postgresql
SQL
0 vote296 views1 answer
IIF
SQL
0 vote348 views1 answer
Sql values that contains certain multiple ids
SQL
8 votes341 views3 answers
Postgres database sizes
SQL
1 vote326 views2 answers
Oracle create synonym
SQL
0 vote339 views1 answer
Dual in db2
SQL
0 vote336 views1 answer
Carbon mysql d m y to y-m-d
SQL