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


INSERT INTO arena.transferred (table_id, table_name, transferred)
SELECT 
    id,
    'ourpension.year_tax_deduction',
    NOW()
FROM ourpension.year_tax_deduction
ON CONFLICT (table_name, table_id) DO UPDATE
    SET transferred = excluded.transferred;