INSERT INTO localdb_image select * from
dblink('host=10.1.1.1
 user=user
 password=password
 dbname=oat', 'SELECT e.* FROM image e JOIN archived f ON e.image_id=f.image_id AND e.dd=f.dd') tt(
      id int ,
  drive_id character varying(255) ,
 ) ;

WHERE NOT EXISTS (SELECT 1 from localdb_image ei where ei.id = e.id)