Postgres Pro
Downloads
Home   >   mailing lists

Converting file -Invalid data format on input DATE - Mailing list pgsql-novice

From Fred Wohlfert
Subject Converting file -Invalid data format on input DATE
Date
Msg-id 41A3AD47.8080008@ehbmail.com
Whole thread Raw
Responses Re: Converting file -Invalid data format on input DATE
List pgsql-novice
Tree view 
I am converting data from  dBaseIII format trying to load into Postgresql.

I am having a problem with DATE field, the file I am working with does
not have any data for
this field on some records.  I have been fixing other problems with sed,
however I am stumped with this.

Will Postgresql take a null as input for a DATE field?

Does anyone know how to specify the null character in SED?

Thanks in advance.

pgsql-novice by date:

Previous
From: "Jeff Flowers"
Date:
Subject: Multi-Row Inserts And Blobs
Next
From: Pradeep Kumar
Date:
Subject: Replacing old tuples on insert