Skip site navigation (1) Skip section navigation (2)

Re: Copy to another server

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Sistemas C(dot)M(dot)P(dot)" <sistemascmp(at)redynet4(dot)com(dot)ar>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Copy to another server
Date: 2006-09-30 02:56:41
Message-ID: 20060930025641.GA8973@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Sep 29, 2006 at 10:41:33 -0300,
  "Sistemas C.M.P." <sistemascmp(at)redynet4(dot)com(dot)ar> wrote:
> I need to select a group of records in one table, and then copy this group to similar table in another database and another server.
> How can I do this?

Long at using the dblink contrib module. If that isn't available
to you, then you can select the data into a temp table and use copy
to produce csv output (in 8.2 you will be able to skip the temp table
step) and then import the csv file into the other database.

In response to

pgsql-admin by date

Next:From: arsiDate: 2006-10-01 20:31:03
Subject: String handling function, substring vs. substr
Previous:From: eduardo maldonadoDate: 2006-09-29 22:38:53
Subject: Unsuscrib me please

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group