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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html