am new at dealing with PostgreSQL
I was using PGAdmin and needed to export some data from a query I had run
and then import it in another DB.
*my columns names* : id (int4), name (varchar), time_starp(timestamp)
so I followed these instructions
http://www.question-defense.com/2010/10/15/how-to-export-from-pgadmin-export-pgadmin-data-to-csv
till "Export Configuration window" , I had to choose the ";" coz the ","
didn't separate the columns right in the csv file.
but when I import this file to another postgreSQL DB by using:
*COPY Table FROM '[insert .csv dir here]' USING DELIMITERS ',' CSV WITH
HEADER*
I got this error :
*ERROR: invalid input syntax for integer: "id;name;timestamp"*
am not sure whats wrong here
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5458103.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.