Обсуждение: About selected data dump

Поиск
Список
Период
Сортировка

About selected data dump

От
longlong
Дата:
hello,all

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?

Re: About selected data dump

От
"Albe Laurenz"
Дата:
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