On Mar 14, 2012, at 6:32 PM, Andy Colson wrote: > On 03/14/2012 08:16 PM, Scott Marlowe wrote: >> >> >> Can you run it through sed and replace the "0000-00-00 00:00:00" to >> NULL (no quotes) ? That should work. >> > > I think COPY (depending on arguments) uses \N by default. > > Another option is to pull it into a temp table and make fix it up from there. > > -Andy
Thanks to all who responded. I appreciate it very much. Yes, that is a good idea. I wasn't sure how to use the NULL clause of the copy command, but I did wonder about other null values in the data set. There are many as this database grew up over 15+ years of use and many renditions of the client application. I am not familiar with sed, except for some trivial bits I nicked off the web. Enough to know it works, and to be dangerous. Nonetheless, using SED may be the way to go as there are two tables that contain a bit over 3,000,000 rows each. - Mark -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
