I am new Postgres. I am getting constraint violation errors while importing a large CSV file.
I want to disable all of the database constraints temporarily - I do not know how to do this.
I am new Postgres. I am getting constraint violation errors while importing a large CSV file. I want to disable all of the database constraints temporarily - I do not know how to do this. |
||||
|
It really depends which constraints are violated. You neglected to disclose that in your question. To disable triggers (including foreign key constraints):
Be sure to revert it afterwards:
However, this does not disable AlternativeAn alternative would be to import your CSV file into a temporary copy of the target table and repair any data that would violate constraints before inserting from there. Depends on the size of the file and available RAM. You could also make this a regular table for huge files or longer processing.
For instance, to remove duplicates from imported data as well as between import and existing data:
|
|||||||||
|