DATE Error: COPY
От | Kumar S |
---|---|
Тема | DATE Error: COPY |
Дата | |
Msg-id | 20040922180141.56861.qmail@web51401.mail.yahoo.com обсуждение исходный текст |
Список | pgsql-novice |
Dear group, I am using COPY for mass upload of my data. I created a table with one coulmn as Create table xxxx ( ....................., ....................., fc_date_annotation DATE, ....................., ..................... ), In my data : The Date_annotation column has date in the following format: 23-Jun-04. When I copy my data I get the following error: Array2=> Copy <table> from '../../file'; ERROR: invalid input syntax for type date: "GeneChip Array" CONTEXT: COPY affy_hg_focus, line 1, column fc_annotation_date: "GeneChip Array" The date format in my data file is POSTGRES- EUROPEAN I reset my settings to match postgres style: array2=> set datestyle to 'POSTGRES,European'; SET marray2=> Show datestyle; DateStyle --------------- Postgres, DMY (1 row) Could any one please suggest what should be done in this case. Thanks -Kumar __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail
В списке pgsql-novice по дате отправления: