Search Postgresql Archives

copy in date string "00-00-00 00:00:00"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am migrating a data set from Oracle 8i to PG 9.1. The process is to export data into csv files, then use the pg "copy table from file csv header" statement to load the tables.

There are a number of date columns in the tables that include empty value (null), valid dates, and some with the time component only. The empty values are being output as 00-00-00 00:00:00.

The import is falling over on rows that contain these "zero" dates. 

I can adjust the NLS session format of the date string, within a small range, in the oracle environment. However, each form I have attempted still results in these "zero" date values in the csv file.

I am thinking of run the csv files through a filter to change the "00-00-00 00:00:00" to an empty value. 

Is there a way for postgres to handle this?

- Mark
-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux