Re: About selected data dump

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: About selected data dump
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C24FA7DE@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на About selected data dump  (longlong <asfnuts@gmail.com>)
Список pgsql-general
longlong wrote:
> I want to transmit data from a database to another partly,
> which means only data that selected in a table will be transmit.
>
> I can select data , and then inert or update rows one by one.
> But is there any way better?

You can export part of a table with
COPY (sql query) TO 'file'
and import it into another database with another COPY statement.

Is that what you need?

Yours,
Laurenz Albe

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

Предыдущее
От: longlong
Дата:
Сообщение: About selected data dump
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Design Question (Time Series Data)