> > select usename,relname, tgname, tgtype, proname, prosrc, tgisconstraint, > > tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs, > > tgattr, tgargs from (pg_trigger join pg_class c on tgrelid=c.oid ) > > join pg_proc on (tgfoid=pg_proc.oid) join pg_user pu on > > c.relowner=pu.usesysid where pu.usename='YOURUSERNAME'; > > > > yes i got the answer by this query..
select relname, tgname, tgtype, proname, prosrc, tgisconstraint, tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs, tgattr, tgargs from (pg_trigger join pg_class on tgrelid=pg_class.oid) join pg_proc on (tgfoid=pg_proc.oid) where tgname not ilike '%constraint%' and tgname not ilike 'pg%'; ---- the query which you had given shown the implicit triggers which is created for maintaining the constraints.. -- so the query which i had given will show the user created triggers... THANKS
