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


SELECT
    'dev' AS source_schema,
    id,
    code,
    name
FROM dev.query_model
WHERE template ILIKE '%form_id%'
   OR template ILIKE '%landscape_form%'
   OR template ILIKE '%contract_params%'

UNION ALL

SELECT
    'dev_local' AS source_schema,
    id,
    code,
    name
FROM dev_local.query_model
WHERE template ILIKE '%form_id%'
   OR template ILIKE '%landscape_form%'
   OR template ILIKE '%contract_params%'
ORDER BY source_schema, name;