0
Good afternoon , we are trying to make a trigger in the laboratory of our system , We are currently trying to make even distinct bases share the product table , ai would work like this every change made in the table on one basis altered in the other , Could you do that ? Thanks in advance
These are the tables
And this is the table I want to see if there’s a way to share with the other bank.
use dblink : http://www.postgresonline.com/journal/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html
– Augusto Vasques
For this version (2014) the only solution is dblink, evaluate if it really meets your needs. In newer versions there is the possibility to use a Foreign Data Wrapper.
– anonimo
I don’t know what the requirements of your (s) application(s) are but you have already evaluated whether the use of different schemas, in place of different databases, would not be more appropriate to your environment since you want to share tables?
– anonimo