Re: Hiding table structure information

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Aaron Bono <postgresql(at)aranya(dot)com>
Cc: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, carlosreimer(at)terra(dot)com(dot)br, rodrigo(dot)sakai(at)zanthus(dot)com(dot)br, pgsql-admin(at)postgresql(dot)org
Subject: Re: Hiding table structure information
Date: 2006-06-28 00:31:23
Message-ID: C38D2B1B-FD84-4A13-B2AA-77884507E83E@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jim Nasby 2006-06-28 00:32:19 Re: Jobs
Previous Message Jim Nasby 2006-06-28 00:25:48 Re: 8.x Vaccum/Autovacuum settings