select tgname, conname, t.tgrelid::regclass, t.tgconstrrelid::regclass,

c.conrelid::regclass, c.confrelid::regclass

from pg_trigger t join pg_constraint c on (t.tgconstraint = c.oid)

where tgname = 'parted_trigger'

order by t.tgrelid::regclass::text;

tgname | conname | tgrelid | tgconstrrelid | conrelid | confrelid

----------------+----------------+--------------------+-------------------+--------------------+-----------

select tgname, conname,t.tgrelid::regclass,t.tgconstrrelid::regclass,

c.conrelid::regclass,c.confrelid::regclass

from pg_trigger tjoin pg_constraint con (t.tgconstraint=c.oid)

where tgname='parted_trigger'

order byt.tgrelid::regclass::text;

droptable parted_referenced, parted_trigger, unparted_trigger;