Re: importing db as text files

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!).

It can be frustrating to deal with postgresql, but I've come to appreciate
the requirement that you clean your data before you COPY it.

Cheers,
Murthy

PS: Sorry "expect", I meant to send to the list, not directly to you. (I
guess I'd better just hit "reply to all", and not edit the "To:" line.)