Re: Hiding table structure information - Mailing list pgsql-admin

From Jim Nasby
Subject Re: Hiding table structure information
Date
Msg-id C38D2B1B-FD84-4A13-B2AA-77884507E83E@pervasive.com
Whole thread Raw
In response to Re: Hiding table structure information  ("Aaron Bono" <postgresql@aranya.com>)
List 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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



pgsql-admin by date:

Previous
From: Jim Nasby
Date:
Subject: Re: archive_log command...
Next
From: Jim Nasby
Date:
Subject: Re: Jobs