-- Колонки, которые используют тип 11498
SELECT n.nspname, c.relname, a.attname, a.atttypid
FROM pg_attribute a
JOIN pg_class c ON c.oid = a.attrelid
JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE a.atttypid = 11498;
SELECT c.oid, c.conname, c.conrelid::regclass
FROM pg_constraint c
WHERE c.contype IN ('f', 'c', 'p', 'u')
AND (
11498 = ANY(c.conkey) OR 11498 = ANY(c.confkey)
);
SELECT p.oid, p.proname
FROM pg_proc p
WHERE p.prorettype = 11498
OR 11498 = ANY(p.proargtypes);