ohp(at)pyrenet(dot)fr wrote:
> I'd love to find a query against pg_triggers giving the table name for
> each RI_ConstraintTrigger_xxx.
SELECT t.tgname, c.relname, tgconstrname FROM pg_trigger t, pg_class c
WHERE t.tgrelid = c.oid AND tgname like 'RI_ConstraintTrigger_%';
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com