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


SELECT
    table_schema,
    table_name,
    column_name,
    data_type,
    column_default,
    is_identity,
    identity_generation,
    is_nullable
FROM information_schema.columns
WHERE (
    table_schema = 'integration'
    AND table_name = 'dict_360_to_lkk_notification_types'
)
OR (
    table_schema = 'report'
    AND table_name = 'unv_notification_queue'
)
ORDER BY table_schema, table_name, ordinal_position;






SELECT *
FROM integration.dict_360_to_lkk_notification_types
WHERE type_code = 12
   OR type_name ILIKE '%вычет%';