X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 234D49FA5E6 for ; Tue, 27 Jun 2006 12:58:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 50599-09 for ; Tue, 27 Jun 2006 12:57:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 6E8859FA50D for ; Tue, 27 Jun 2006 12:57:49 -0300 (ADT) Received: (qmail 8806 invoked by uid 500); 27 Jun 2006 16:01:48 -0000 Date: Tue, 27 Jun 2006 11:01:48 -0500 From: Bruno Wolff III To: Aaron Bono Cc: "Jonah H. Harris" , carlosreimer@terra.com.br, rodrigo.sakai@zanthus.com.br, pgsql-admin@postgresql.org Subject: Re: Hiding table structure information Message-ID: <20060627160148.GA7623@wolff.to> Mail-Followup-To: Bruno Wolff III , Aaron Bono , "Jonah H. Harris" , carlosreimer@terra.com.br, rodrigo.sakai@zanthus.com.br, pgsql-admin@postgresql.org References: <000301c6995b$7d5c9150$4700a8c0@TREEZANTHUS> <36e682920606261407i69287262n4942f7c9642f552e@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/259 X-Sequence-Number: 22221 On Mon, Jun 26, 2006 at 19:48:32 -0500, Aaron Bono 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.