-- Export from source DB
COPY (SELECT emp_id, first_name, last_name, email, salary
       FROM employees WHERE status = 'active')
TO '/tmp/employees_export.csv'
WITH (FORMAT csv, HEADER true, DELIMITER ',');

-- Import into target DB (different server)
COPY employees_staging(emp_id, first_name, last_name, email, salary)
FROM '/tmp/employees_export.csv'
WITH (FORMAT csv, HEADER true);

-- Verify import count
SELECT COUNT(*) FROM employees_staging;