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 C2CEE9FAC76 for ; Tue, 27 Jun 2006 21:50:58 -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 32024-01-2 for ; Tue, 27 Jun 2006 21:50:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 93AE59F9DCC for ; Tue, 27 Jun 2006 21:50:54 -0300 (ADT) Received: from [10.82.1.60] (docboy.decibel.org [65.86.67.34]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id F314056451; Tue, 27 Jun 2006 19:50:47 -0500 (CDT) In-Reply-To: References: <000301c6995b$7d5c9150$4700a8c0@TREEZANTHUS> <36e682920606261407i69287262n4942f7c9642f552e@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: "Jonah H. Harris" , carlosreimer@terra.com.br, rodrigo.sakai@zanthus.com.br, pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: Hiding table structure information Date: Tue, 27 Jun 2006 19:31:23 -0500 To: Aaron Bono X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/269 X-Sequence-Number: 22231 On Jun 26, 2006, at 7:48 PM, 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? google: postgresql dblink > 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. http://gborg.org/slony1 -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461