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;