Thread: About selected data dump

About selected data dump

From
longlong
Date:
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

From
"Albe Laurenz"
Date:
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