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
