valide date in an ascii file - Mailing list pgsql-interfaces

From dhoubrechts
Subject valide date in an ascii file
Date
Msg-id 3C5AF9A0.F84B1D73@cybernet.be
Whole thread Raw
Responses Re: valide date in an ascii file
List pgsql-interfaces
I'm trying to copy data from an ascii file to a postgres table using :
copy table using 'Home/tetrao/tetrao.txt' using delimiters ';';
My question is : How do i enter valide dates form that file when the
column is empty (;;)? Postgres want some valide date and don't want ''

Please help !


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp Format on Binary Cursor
Next
From: Jeff Eckermann
Date:
Subject: Re: valide date in an ascii file