0

I want to import CSV in PGAdmin III with ID field auto increment. I am not able to do it. The CSV contains a column as ID with null values.

need help.

Apurva
  • 9
  • 2
  • 1
    What have you tried so far and why hasn't it worked/what error did you get? – 404 Sep 19 '19 at 13:28
  • I created a simple table named person in PGAdmin 3. The columns were ID, Name and Region. I assigned ID as primary key and by default its not null. Then I created a CSV file with same columns and I kept the ID column blank. The name and the region column contains data. I actually wanted to import the CSV in the database and the ID field should be auto incremented. While importing I took the format CSV and encoding UTF8. It gives me an error as null value in column "ID" violates not null constrains. – Apurva Sep 20 '19 at 03:16

0 Answers0