Import CSV date issues
От | Sarfraz Nawaz |
---|---|
Тема | Import CSV date issues |
Дата | |
Msg-id | CACDibgGgqk4TDddHFZmCAxz+cTWxEamva+Yow4bYktzNteF52g@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Import CSV date issues
Re: Import CSV date issues |
Список | pgsql-novice |
Hello everyone, I am just setting up a db using PostgreSQL-9.1 and having issues with importing from a CSV file. I have created a table "durations" in "mydb" using the following SQL command, CREATE TABLE durations ( startdate date, enddate date, starttime time without time zone, endtime time without time zone, days integer, hours integer, minutes integer, somefield text, locid integer ); mydb has the proper date style set as well as shown with this, mydb=> SHOW datestyle; DateStyle ----------- ISO, DMY (1 row) However, when I try to import data into "durations" table from a CSV file, I get this error which is puzzling me because the date in the CSV file is in the same DMY format that the db should be expecting. I have also tried by giving "durations(startdate, enddate, ....)" format as well but same result. mydb=> \copy durations FROM 'myfile.csv' DELIMITER ',' CSV; ERROR: invalid input syntax for type date: "12/09/2011" CONTEXT: COPY durations, line 1, column startdate: "12/09/2011" The lines in the CSV file look like the following, 12/09/2011,12/09/2011,11:12,12:12,0,1,60,NO,82889 Any suggestions please? Thank you for reading through :)
В списке pgsql-novice по дате отправления: