Re: [GENERAL] copy from file with null date fields

1998-06-04 Thread William D. McCoy
David, Thanks for your help. I did have null values represented as zero-length strings. I'll just run these files through a sed script to replace the zero-length strings with "\N". David Hartwig writes: > How are you representing NULL in the source file. Blank or zero length > strings are

Re: [GENERAL] copy from file with null date fields

1998-06-04 Thread David Hartwig
How are you representing NULL in the source file. Blank or zero length strings are not NULL. They are treated as illegal dates. I believe "\N" is used to represent NULL in the copy in/out. William D. McCoy wrote: > I'm running Postgres 6.3.2 on a Sparc20 running Solaris 2.5.1 and I'm > hav