Обсуждение: list user created triggers

hi,

how to find trigger names in my database ?

using psql 7.4

the following query shows system triggers, i want only to list the
triggers created by me

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);