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


SELECT
    n.nspname AS schema_name,
    c.relname AS table_name,
    a.attname AS column_name,
    d.description
FROM pg_description d
JOIN pg_class c
    ON c.oid = d.objoid
JOIN pg_namespace n
    ON n.oid = c.relnamespace
LEFT JOIN pg_attribute a
    ON a.attrelid = c.oid
    AND a.attnum = d.objsubid
WHERE n.nspname = 'prod_line'
  AND (
       d.description ILIKE '%целев%'
    OR d.description ILIKE '%собствен%'
    OR d.description ILIKE '%страхов%'
    OR d.description ILIKE '%отчислен%'
    OR d.description ILIKE '%сс%'
    OR d.description ILIKE '%ср%'
  )
ORDER BY c.relname, a.attnum;