Re: Converting file -Invalid data format on input DATE

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Fred Wohlfert <fredwohlfert(at)ehbmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Converting file -Invalid data format on input DATE
Date: 2004-11-26 15:04:52
Message-ID: 20041126150452.GA26221@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Nov 23, 2004 at 16:36:07 -0500,
Fred Wohlfert <fredwohlfert(at)ehbmail(dot)com> wrote:
> 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?

If you mean an empty string, no that isn't a valid date. You can store
SQL NULLs in a date column as long as you don't have any constraints that
would prohibit them.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-11-26 15:53:56 Re: Querying a list field against another list
Previous Message Kjetil Haaland 2004-11-26 14:56:41 problem with memory allocation