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


SELECT
    table_schema,
    table_name,
    column_name,
    data_type
FROM information_schema.columns
WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
  AND (
       lower(column_name) LIKE '%landscape_form%'
    OR lower(column_name) = 'form_id'
    OR lower(column_name) LIKE '%form_id%'
    OR lower(column_name) LIKE '%template%'
    OR lower(column_name) LIKE '%blank%'
  )
ORDER BY table_schema, table_name, column_name;