Re: loading and unloading rows

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: loading and unloading rows
Дата
Msg-id 200211080446.gA84kOw29553@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: loading and unloading rows  (Naomi Walker <nwalker@eldocomp.com>)
Список pgsql-admin
Naomi Walker wrote:
> Can we add unload/load functionality to the list, please?
>
>
>
> > > >Yes, agreed, it would be nice to have WHERE as part of COPY.  In fact, I
> > > >like Informix's solution, which merges data in/out with INSERT/SELECT:
> > > >
> > > >         UNLOAD TO '/tmp/x'
> > > >         SELECT *
> > > >         FROM tab;
> > > >
> > > >and
> > > >
> > > >         LOAD FROM '/tmp/x'
> > > >         INSERT INTO tab;

I have thought of that.  We would probably join COPY to INSERT/SELECT
rather than use LOAD/UNLOAD.  The problem is that the COPY code reads
right out of the table, rather than reading from the executor.  This
change would require that.  You can do it now by using TEMP tables to do
the COPY.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum return codes (vacuum as db integrity check?)
Следующее
От: Timothy D McKernan
Дата:
Сообщение: Uninitialized pages notices