SELECT
table_schema,
table_name,
ordinal_position,
column_name,
data_type,
udt_name,
is_nullable,
column_default
FROM information_schema.columns
WHERE
(
table_schema = 'report'
AND table_name = 'unv_registry_item'
)
OR (
table_schema = 'ourpension'
AND table_name IN ('individual', 'contract')
AND column_name = 'id'
)
ORDER BY
table_schema,
table_name,
ordinal_position;