About selected data dump

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