Re: importing db as text files

On Fri, 15 Aug 2003 11:32:20 -0400
Murthy Kambhampaty <murthy(dot)kambhampaty(at)goeci(dot)com> wrote:

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