Import and overwrite duplicate rows

You can import into a temporary table. Then you can delete rows that were already there before you copy over the new data:

create temporary table import_drivers as select * from drivers limit 0;

copy import_drivers from stdin;

begin transaction;

delete  from drivers
where   id in
        (
        select  id
        from    import_drivers
        );

insert  into drivers
select  *
from    import_drivers;

commit transaction;