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

SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office' 
  AND table_name = 'eps_transaction'
ORDER BY ordinal_position




SELECT table_name 
FROM information_schema.tables
WHERE table_schema IN ('back_office', 'ourpension')
  AND (table_name ILIKE '%sub%' 
   OR table_name ILIKE '%subconto%'
   OR table_name ILIKE '%strategy%'
   OR table_name ILIKE '%strateg%')