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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
