Re: Copy from csv - timestamp issue

IanHingley wrote:
> First post here from a total postgresql newbie.  Many years working on SQL
> Server, but ...
> 
> I'm trying to copy in some csv data.
> 
> My first column is, confusingly, called datetime and has datatype timestamp
> without time zone.
> This is followed by flow_m3hr (real), sitename (integer) and pmac (integer).
> 
> Here's my command:
> 
> ST_mpcc=# COPY st_mpcc_data FROM 'C:\blahblah\ST_Mpcc_CSV_sample.csv';
> 
> and here's my error:
> 
> ERROR:  invalid input syntax for type timestamp: "2008-07-11
> 03:00:00,0,10545079
> ,26739"
> CONTEXT:  COPY st_mpcc_data, line 1, column datetime: "2008-07-11
> 03:00:00,0,105
> 45079,26739"
> 
> Does this imply it's trying to place the entire row of data into the first
> field?
> 
> If so, how do I prevent it?

If you want to import CSV, you must tell COPY that because the default
format is different.

COPY ... FROM ... (FORMAT csv);

or, on older releases,

COPY ... FROM ... CSV

Yours,
Laurenz Albe