Re: About selected data dump

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "longlong *EXTERN*" <asfnuts(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: About selected data dump
Date: 2007-10-04 08:37:59
Message-ID: D960CB61B694CF459DCFB4B0128514C24FA7DE@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-10-04 09:20:19 Re: Design Question (Time Series Data)
Previous Message Goboxe 2007-10-04 06:23:06 Re: Auto-partitioning?