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


SELECT
    table_schema,
    table_name,
    string_agg(column_name, ', ' ORDER BY ordinal_position) AS matched_columns
FROM information_schema.columns
WHERE
       column_name ILIKE '%amount_from%'
    OR column_name ILIKE '%amount_to%'
    OR column_name ILIKE '%contribution_ss%'
    OR column_name ILIKE '%contribution_sr%'
GROUP BY
    table_schema,
    table_name
ORDER BY
    table_schema,
    table_name;