[Answer]-Postgres – load from sql file (skip errors), leave existing ones and create non existing

Import your data to a temporary table and then just use something like:

insert into real_table_name
select * from temporary_table_name
where id not in (select id from real_table_name);