Re: COPY, \copy with defaults

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
> > I guess this is a feature request since I can't
> figure
> > out a way to do it directly in postgresql (plus
> > COPY/\copy isn't in SQL specs).
>
> You do know that COPY uses the column defaults for
> all columns not
> listed in the input list?

Yep, but that won't work (foreign key id's, timestamps
other than now(), ...)

CSN

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com