Importing CSV file into PostgreSQL -


Using the MySQL Administrator GUI Tool I have exported some data tables obtained in CSV files from a SQL dumpfile.

Then I tried to import these CSV files in the PostGrace SQL database, which I have tried to enter in the PostGrace COPY command

copy text from '[insert Ccsv here] 'DELIMITERS', 'CSV;
  Error: invalid input syntax for integer  

and the same command without delimiter component too.

: "ID" CONTEXT: Copy Text, Line 1, Column ID: "id"

Finally my question is, what are some ideas and solutions to this problem? Maybe I have done something to create CSV files? Or did I make a fraudulent mistake somewhere else?

If you have the header column then only the header qualifier

per statement according to the documentation to leave that line

Comments