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

3 votes250 views1 answer
Mssql remove column
SQL
0 vote249 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote243 views1 answer
SQL Server modify_timestamp trigger
SQL
3 votes280 views1 answer
Create a table with an id in mysql
SQL
37 votes338 views6 answers
Mysql update
SQL
6 votes249 views2 answers
Mysql first day of month
SQL
0 vote245 views1 answer
Sql create table with datetime automatically
SQL
0 vote254 views1 answer
This week mysql
SQL
0 vote251 views2 answers
Postgresql get last day of month
SQL
0 vote261 views1 answer
Test database for sql
SQL