DATE column doesn't like empty string or null value - Mailing list pgsql-novice

From michael@floog.net
Subject DATE column doesn't like empty string or null value
Date
Msg-id 1093372687.412b8b0f1bda7@webmail.floog.net
Whole thread Raw
In response to Re: MySQL vs PostgreSQL  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: DATE column doesn't like empty string or null value
List pgsql-novice
Hi Group:

I used COPY to import a bunch of data into my PG database.  The db has
one table so far, and the table has a column using DATE with a
datestyle of US,ISO.

To get all the data to copy correctly, I created a meaningless date
entry of 01/01/2001 and inserted this into every row in the database.

I would like to delete these bogus date entries and leave the date
column blank until proper dates can be filled in.

What command can I use to remove all the 01/01/2001 entries in every row
and leave it blank.

Thank you for your time and patience.

Mike



pgsql-novice by date:

Previous
From: John Browne
Date:
Subject: Questions about pg_dump file
Next
From: Thuffman00@aol.com
Date:
Subject: Another date/time question using libpq