Re: importing db as text files

On Fri, 15 Aug 2003 00:32:01 -0700 (PDT)
Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:

>
> On Thu, 14 Aug 2003, expect wrote:
>
> > On Thu, 14 Aug 2003 12:46:07 -0500
> > Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> > > Note that it isn't obvious what empty strings should map to for numbers.
> > > NULL and 0 make about as much sense as using the default value.
> >
> > Well I'm new here but it seems to me they should map to the default value
> > for that column. Why wouldn't they?
>
> One problem with doing that is that it's inconsistent.

Please elaborate. How is it inconsistent, exactly?

>
> 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?

Oh a test....

Does the \. end the STDIN input?

Where's the null option? Don't you mean:

copy test from stdin with delimiter ',' null '';

In this case I would expect the row to have:

a | b
----------
|
abc | 5

Is this too much to expect?

>
>
>