If you use the COPY statement where integrities are involved, after the copy operation you must check for and replace or delete rows with values violating the integrities. Alternatively, you can copy to a temporary table and create an INSERT statement that uses a subselect statement on the temporary table.