From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: COPY, \copy with defaults |
Date: | 2004-08-09 05:00:18 |
Message-ID: | 20040809050018.67016.qmail@web52903.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- 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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2004-08-09 05:20:06 | Re: Losing records when server hang |
Previous Message | Tom Lane | 2004-08-09 04:55:08 | Re: COPY, \copy with defaults |