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