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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
