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 votes118 views2 answers
Oracle foreign key reference table
SQL
49 votes171 views6 answers
Alter table add column
SQL
13 votes99 views2 answers
Check if value is null mysql
SQL
8 votes107 views2 answers
Phpmyadmin default password
SQL
0 vote107 views1 answer
Sql server order by nulls last
SQL
2 votes138 views1 answer
Find column in all stored procedures sql server
SQL
1 vote111 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote122 views1 answer
Compare if is null sql
SQL
4 votes116 views2 answers
REST API
SQL
0 vote107 views1 answer
Qt qsql check if table exist
SQL