Re: COPY, \copy with defaults - Mailing list pgsql-general

From CSN
Subject Re: COPY, \copy with defaults
Date
Msg-id 20040809050018.67016.qmail@web52903.mail.yahoo.com
Whole thread Raw
In response to Re: COPY, \copy with defaults  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> CSN <cool_screen_name90001@yahoo.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY, \copy with defaults
Next
From: "Scott Marlowe"
Date:
Subject: Re: Losing records when server hang