From: | Shadin_ <w_ward_w(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Error while importing CSV file |
Date: | 2012-02-05 16:04:16 |
Message-ID: | 1328457856624-5458103.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2012-02-05 16:25:32 | Re: Error while importing CSV file |
Previous Message | Edwin Quijada | 2012-02-05 04:45:56 | Your partner Edwin needs your help! |