From: Bruno Wolff III <bruno@wolff.to>
To: Aaron Bono <postgresql@aranya.com>
Cc: Jonah H. Harris <jonah.harris@gmail.com>
Cc: carlosreimer@terra.com.br
Cc: rodrigo.sakai@zanthus.com.br
Cc: pgsql-admin@postgresql.org
Subject: Re: Hiding table structure information
Date: Tue, 27 Jun 2006 11:01:48 -0500
Message-ID: <20060627160148.GA7623@wolff.to> (raw)
In-Reply-To: <bf05e51c0606261748v6188d251qb515466b71e17d48@mail.gmail.com>
References: <000301c6995b$7d5c9150$4700a8c0@TREEZANTHUS>
<PEEPKDFEHHEMKBBFPOOKMENNDBAA.carlosreimer@terra.com.br>
<36e682920606261407i69287262n4942f7c9642f552e@mail.gmail.com>
<bf05e51c0606261748v6188d251qb515466b71e17d48@mail.gmail.com>
On Mon, Jun 26, 2006 at 19:48:32 -0500,
Aaron Bono <postgresql@aranya.com> wrote:
> Would there be a way to set up the 2 databases - one with the tables and
> data and the other that connects to the first with views into the second
> database?
>
> Actually I am interested because I will soon need to set up a way to feed
> data to multiple databases and would love to have a stored procedure or
> trigger that, when the data is updated in one database, the changes are
> propagated to all the other databases.
There is a contrib package dblink that will do at least some of what you
want.
You might also see if just separating stuff into different schemas will
be good enough for you. That would allow you to have separate name spaces
but still be able to reference tables in other schemas efficiently.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, postgresql@aranya.com, jonah.harris@gmail.com, carlosreimer@terra.com.br, rodrigo.sakai@zanthus.com.br
Subject: Re: Hiding table structure information
In-Reply-To: <20060627160148.GA7623@wolff.to>
References: <000301c6995b$7d5c9150$4700a8c0@TREEZANTHUS> <PEEPKDFEHHEMKBBFPOOKMENNDBAA.carlosreimer@terra.com.br> <36e682920606261407i69287262n4942f7c9642f552e@mail.gmail.com> <bf05e51c0606261748v6188d251qb515466b71e17d48@mail.gmail.com> <20060627160148.GA7623@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox