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 '%вычет%';