date format and copy command - Mailing list pgsql-general

From Bill Barnes
Subject date format and copy command
Date
Msg-id 200004260523.BAA05037@smtp10.atl.mindspring.net
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: "Michael S. Kelly"
Date:
Subject: Having trouble getting readline functional in psql
Next
From: "Bill Barnes"
Date:
Subject: kpgsql query executes but does not complete