Re: Error while importing CSV file

On Feb 5, 2012, at 11:04, Shadin_ <w_ward_w(at)hotmail(dot)com> 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 ','
...