Advertisement
Guest User

Untitled

a guest
Mar 24th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. -- get list of functions
  2. SELECT proname as fname, prosrc, pg_get_functiondef(p.oid)
  3. FROM pg_catalog.pg_namespace n
  4. JOIN pg_catalog.pg_proc p ON pronamespace = n.oid
  5. WHERE nspname = 'accounting'
  6. OR nspname = 'dbo'
  7. OR nspname = 'permission'
  8. OR nspname = 'printforms'
  9. OR nspname = 'public'
  10. AND proname <> 'last_agg';
  11.  
  12. -- get definition only
  13. --SELECT pg_get_functiondef(oid) AS definition, proname FROM pg_proc WHERE proname = 'hstore';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement