Skip to content

Instantly share code, notes, and snippets.

@dannyvassallo
Last active April 27, 2017 20:50
Show Gist options
  • Save dannyvassallo/b62ebd509d4c5298cc3217f86724f055 to your computer and use it in GitHub Desktop.
Save dannyvassallo/b62ebd509d4c5298cc3217f86724f055 to your computer and use it in GitHub Desktop.
Get all postgres functions and triggers

List all functions

SELECT  proname, prosrc
FROM    pg_catalog.pg_namespace n
JOIN    pg_catalog.pg_proc p
ON      pronamespace = n.oid
WHERE   nspname = 'public';

List all triggers

select * from information_schema.triggers;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment