Re: About selected data dump - Mailing list pgsql-general

From Albe Laurenz
Subject Re: About selected data dump
Date
Msg-id D960CB61B694CF459DCFB4B0128514C24FA7DE@exadv11.host.magwien.gv.at
Whole thread Raw
In response to About selected data dump  (longlong <asfnuts@gmail.com>)
List 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 by date:

Previous
From: longlong
Date:
Subject: About selected data dump
Next
From: "Pavel Stehule"
Date:
Subject: Re: Design Question (Time Series Data)