Загрузка данных


-- Колонки, которые используют тип 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);