test=# select tgrelid, tgname, tgargs from pg_trigger where tgrelid = 32656809; tgrelid | tgname | tgargs ----------+-------------------------------+----------------------------------------------------------------------- 32656809 | RI_ConstraintTrigger_32656811 | \000slave2\000master\000UNSPECIFIED\000master_id\000id\000 32656809 | RI_ConstraintTrigger_32656817 | \000slave2\000master2\000UNSPECIFIED\000master_id2\000id\000 (2 rows)