Dude you are a legend. I have attempted to mod the query to use just those tables and i think its ok just need confirmation. It would be nice if it had the full text descriptors but I can always use a case to fix it up if necessary.
SELECT c.conrelid::regclass::text AS table_name,
c.contype AS constraint_type, --c = check constraint, f = foreign key constraint, p = primary key constraint, u = unique constraint, t = constraint trigger, x = exclusion constraint
a.attname AS column_name,
c.confmatchtype AS match_type, --f = full, p = partial, s = simple
c.confupdtype AS on_update, --a = no action, r = restrict, c = cascade, n = set null, d = set default
c.confdeltype AS on_delete, --a = no action, r = restrict, c = cascade, n = set null, d = set default
c.confrelid::regclass AS references_table,
ab.attname AS references_field
FROM pg_catalog.pg_constraint c, pg_catalog.pg_attribute a, pg_catalog.pg_attribute ab
WHERE conrelid::regclass = a.attrelid::regclass
AND conkey[1] = a.attnum
AND a.attrelid = ab.attrelid
AND a.attnum = ab.attnum
AND c.conrelid = 'products'::regclass
AND c.contype='f';