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 vote147 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes211 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote137 views1 answer
Postgresql create table with boolean column
SQL
0 vote135 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote107 views2 answers
Sql update from two different database
SQL
11 votes149 views2 answers
Safe mode off mysql
SQL
6 votes145 views3 answers
Commit in sql
SQL
0 vote164 views1 answer
Oracle date summer time
SQL
5 votes95 views1 answer
Postgres upsert
SQL
5 votes140 views3 answers
Postgres show databases
SQL