On 20 okt 2009, at 16.15, Raymond O'Donnell wrote:
On 20/10/2009 05:55, Nate Randall wrote:
However, I need some method of "converting" the
empty string "" values into NULL values after import, so that I can
change the date fields back to date-type. Any suggestions on how
this
could be accomplished?
How about:
update <table> set <column> = null where <column> = '';
You can also do the update and the column data type change in one
fell swoop like so:
ALTER TABLE table_name ALTER COLUMN column_name
SET DATA TYPE DATE USING NULLIF(column_name, '')::DATE;
Sincerely,
Niklas Johansson
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
