Re: duplicate table in two databases - Mailing list pgsql-sql

From Richard Huxton
Subject Re: duplicate table in two databases
Date
Msg-id 412069DB.107@archonet.com
Whole thread Raw
In response to duplicate table in two databases  (Fabio Ferrero <nutella@inwind.it>)
List pgsql-sql
Fabio Ferrero wrote:
> I use postgres 7.2.1 (debian woody) and PHP.
> 
> I've two databases (foo and bar for example) with the same table (ie. 
> stamps).
> 
> It's possible with a single query transfer the data from the stamps 
> table in db foo to the stamps table in db bar?

You might want to look in the contrib/ folder of the source distribution 
(or the equivalent in your packaged installation for "dblink". Haven't 
used it myself, but it can certainly do what you want here.

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Kaloyan Iliev Iliev
Date:
Subject: Inheriting text[] field
Next
From: Richard Huxton
Date:
Subject: Re: CROSS-TAB query help? I have read it cant be done in one