DATE Error: COPY

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: DATE Error: COPY
Date: 2004-09-22 18:01:41
Message-ID: 20040922180141.56861.qmail@web51401.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Rory Campbell-Lange 2004-09-22 21:24:59 Re: Multi Database queries
Previous Message Ron St-Pierre 2004-09-22 17:35:51 Re: Multi Database queries