Showing Tag: "functions" (Show all posts)

How to find List of Stored Procedures/ Functions in PostgresSQL Database

Posted by jineesh uvantavida on Wednesday, December 23, 2020,
Finding procedures without schema name

select n.nspname as schema_name, p.proname as specific_name, l.lanname as language, case when l.lanname = 'internal' then p.prosrc else pg_get_functiondef(p.oid) end as definition, pg_get_function_arguments(p.oid) as arguments from pg_proc p left join pg_namespace n on p.pronamespace = n.oid left join pg_language l on p.prolang = l.oid left join pg_type t on t.oid = p.prorettype where n.nspname not in (...
Continue reading ...
 
 

Translate This Page

 


Make a free website with Yola