"A.Bhuvaneswaran" <bhuvan@symonds.net> writes:
> Where does postgresql store tg_op and tg_when details for a trigger? If i
> am right, it is not in pg_trigger catalog.
No, you're not right. It's encoded in tgtype somehow; you'll have to
look at the trigger code for details (see src/include/catalog/pg_trigger.h
in particular).
regards, tom lane