postgresql - Ignore duplicates when importing from CSV -
i'm using postgresql database, after i've created table have populate them csv file. csv file corrupted , violates primary key rule , database throwing error , i'm unable populate table. ideas how tell database ignore duplicates when importing csv? writing script remove them csv file no acceptable. workarounds welcome too. thank you! : )
on postgresql, duplicate rows not permitted if violate unique constraint. think best option, import csv file on temp table has no constraint, delete duplicate values, , import temp table final table.
Comments
Post a Comment