Re: COPY, \copy with defaults

Поиск
Список
Период
Сортировка
От CSN
Тема Re: COPY, \copy with defaults
Дата
Msg-id 20040809050018.67016.qmail@web52903.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: COPY, \copy with defaults  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COPY, \copy with defaults
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Losing records when server hang