Author: techfox9

PostgreSQL list of triggers ..

Monday, November 21st, 2011 @ 1:05 am

SELECT relname, tgname, usename 
 FROM ( 
     pg_trigger JOIN pg_class ON (tgrelid = pg_class.oid) 
               JOIN pg_proc ON (tgfoid = pg_proc.oid) 
               JOIN pg_user ON (relowner = pg_user.usesysid) 
) 
WHERE tgisinternal = FALSE [ and usename = 'user' ]

Database, PostgreSQL


 


Comments are closed.