>-----Original Message----- >From: expect [mailto:[EMAIL PROTECTED] >Sent: Friday, August 15, 2003 11:56 >To: [EMAIL PROTECTED] >Subject: Re: [GENERAL] importing db as text files > > >On Fri, 15 Aug 2003 11:32:20 -0400 >Murthy Kambhampaty <[EMAIL PROTECTED]> wrote: > >> On Friday, August 15, 2003 03:53, expect >[mailto:[EMAIL PROTECTED] wrote: >> >On Fri, 15 Aug 2003 00:32:01 -0700 (PDT) >> >Stephan Szabo <[EMAIL PROTECTED]> wrote: >> > >> ... >> >> Given >> >> create table test( >> >> a text default 'abc', >> >> b int default 5 >> >> ); >> >> >> >> copy test from stdin with delimiter ','; >> >> , >> >> \. >> >> >> >> What would you expect the values of the row in test >> >> to be? >> > >> > >> ... >> >In this case I would expect the row to have: >> > >> > a | b >> >---------- >> > | >> > abc | 5 >> > >> > >> >Is this too much to expect? >> >> Your expectations don't seem consistent with the table >definition, which >> permits Null values are allowed in (it's ironic you would >add "null ''" to >> the copy statement, which says you want to treat empty >strings as default >> values, not null!). >> > > >Why is it ironic? I don't think you've followed the thread correctly. >It's what I wanted to have happen. > Pardon my dyslexic typing; that was to read: "it's ironic you would add "null ''" to the copy statement, which says you want to treat empty strings as nulls, not default values!"
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
