How to update Remote DB using trigger?
От | Natrayan Kuppusamy - CTD , Chennai |
---|---|
Тема | How to update Remote DB using trigger? |
Дата | |
Msg-id | 809D32F4B095CD489D4B01E655C04D200218172B@narmada.ctd.hcltech.com обсуждение исходный текст |
Список | pgsql-cygwin |
Hi, I am using two Postgre databases in my application. Both are in different in machine. My requirement is that when one database(primary) gets updated then the another database(secondary) should also get updated with the same information updated in primary database. I think trigger will help in this. But I am not sure about the connection to remote database from stored procedure. Can anyone help me? Regards, Natrayan. DISCLAIMER This message and any attachment(s) contained here are information that is confidential, proprietary to HCL Technologies and its customers. Contents may be privileged or otherwise protected by law. The information is solely intended for the individual or the entity it is addressed to. If you are not the intended recipient of this message, you are not authorizedto read, forward, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer
В списке pgsql-cygwin по дате отправления: