On Feb 5, 2012, at 11:04, Shadin_ <w_ward_w@xxxxxxxxxxx> wrote: > > 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 > > > "id;name;timestamp" ... USING DELIMITERS ',' ... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
