date format and copy command

From: "Bill Barnes" <kgbsoft(at)ix(dot)netcom(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: date format and copy command
Date: 2000-04-26 05:24:33
Message-ID: 200004260523.BAA05037@smtp10.atl.mindspring.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using 6.5.3 on SuSE 6.4 and program kpgsql.
Dumped data to a ';' delimited file wherein the date looks like
'1997-12-27'. The date field may be null.

Created the appropriate table using variously date/datetime/timestamp for
data type, set datestyle to ISO/SQL/others.
The copy command is
copy tablename from '/usr/.../namefile.txt' using delimiters ';';

The pgsql response is 'bad date format'.
Recommendations, please.

Thanks,
Bill Barnes

Browse pgsql-general by date

  From Date Subject
Next Message Bill Barnes 2000-04-26 05:44:49 kpgsql query executes but does not complete
Previous Message Michael S. Kelly 2000-04-26 05:21:54 Having trouble getting readline functional in psql