Re: importing db as text files

On Fri, 15 Aug 2003 11:32:20 -0400
Murthy Kambhampaty <murthy.kambhampaty@goeci.com> wrote:

> On Friday, August 15, 2003 03:53, expect [mailto:expect@ihubbell.com] wrote:
> >On Fri, 15 Aug 2003 00:32:01 -0700 (PDT)
> >Stephan Szabo <sszabo@megazone.bigpanda.com> 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.