Re: Import CSV with Dates & Times
От | James David Smith |
---|---|
Тема | Re: Import CSV with Dates & Times |
Дата | |
Msg-id | CAMu32ADucSV2K52sE_qiPW=Gj=YtSXVVHXhB3us+K9bDmJ_rXw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Import CSV with Dates & Times (Simon Riggs <simon@2ndQuadrant.com>) |
Ответы |
Re: Import CSV with Dates & Times
|
Список | pgsql-novice |
Simon, Thanks for this. I don' t have pgloader installed and a quick search seems to suggest it's a Linux tool? I'm working in Windows unfortunately. Maybe a bit more info would be good... Here is my table: create table ibus_17_11_2011( route INTEGER, scheduled_depart_time TIMESTAMP ) Here is my copy command: COPY ibus_17_11_2011 from 'C:/Program Files (x86)/PostgreSQL/8.4/data/ibus_17_11_2011_v2.csv' DELIMITERS ',' CSV; My date looks like this: 2 , 17/11/2011 17:08:35 3 , 17/11/2011 17:08:56 Thanks James On 4 May 2012 12:47, Simon Riggs <simon@2ndquadrant.com> wrote: > On 4 May 2012 12:38, James David Smith <james.david.smith@gmail.com> wrote: > >> Any sugestions please? > > Use pgloader > > -- > Simon Riggs http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-novice по дате отправления: