Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- get list of functions
- SELECT proname as fname, prosrc, pg_get_functiondef(p.oid)
- FROM pg_catalog.pg_namespace n
- JOIN pg_catalog.pg_proc p ON pronamespace = n.oid
- WHERE nspname = 'accounting'
- OR nspname = 'dbo'
- OR nspname = 'permission'
- OR nspname = 'printforms'
- OR nspname = 'public'
- AND proname <> 'last_agg';
- -- get definition only
- --SELECT pg_get_functiondef(oid) AS definition, proname FROM pg_proc WHERE proname = 'hstore';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement