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 vote275 views2 answers
Mysql remove first and last character from string
SQL
0 vote312 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
26 votes269 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote298 views1 answer
Load data infile mariadb slow
SQL
0 vote267 views1 answer
Oracle index hint
SQL
4 votes264 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote276 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote267 views1 answer
Mysql xampp reset root password
SQL
0 vote297 views1 answer
Mysql Selected All Duplicate Rows
SQL
6 votes306 views3 answers
Create database mysql utf8
SQL