We are migrating from Informix to Postgres 7.4.7 and are having a difficult time finding if postgres can insert/update tables across different databases. Namely using functions/triggers when an update/insert is performed on a table it updates/inserts in a table on a different database. Informix can do this with no problem but we were wondering if there is an easy way for postgres to do this. I've searched numerous sites and found vague answers. Thanks in advance.
If you have databases that are dependent on each others data you should probably move those databases into a new schema within one database...
See the create schema command.
Otherwise you could use dblink but it would not be my suggestion.
Sincerely,
Joshua D. Drake
Eric Jones
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
-- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
