Re: [SQL] Copying null values

2001-04-10 Thread Christof Glaser
On Tuesday, 10. April 2001 14:17, Amanda Riera wrote: > I would like empty fields from a file being recognised as NULL > values. It doesn't seem to work when a COPY is done, but when I make > an INSERT without > specifying the value, this is recognised as a NULL > > The file I want to copy is: > >

[SQL] Copying null values

2001-04-10 Thread Amanda Riera
Hi all, I am using: Debian 2.2 (kernel 2.2.18) PgSQL version 7.0.3 I would like empty fields from a file being recognised as NULL values. It doesn't seem to work when a COPY is done, but when I make an INSERT without specifying the value, this is recognised as a NULL The file I want to copy is