Copy from csv - timestamp issue
От | IanHingley |
---|---|
Тема | Copy from csv - timestamp issue |
Дата | |
Msg-id | 1385727392068-5780855.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: Copy from csv - timestamp issue
|
Список | pgsql-novice |
Hi all 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 not, what else is wrong? Thanks for your help Ian -- View this message in context: http://postgresql.1045698.n5.nabble.com/Copy-from-csv-timestamp-issue-tp5780855.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
В списке pgsql-novice по дате отправления: