Linking Tables from 2 databases

[911TwinTurbo]

Hi All,

I am wondering if there is a way to create a linked table in postgresql. I have a table in a DB i created and i want the table in a second DB, linked, so that any mods to one table apply to both.

Any help is appreciated.

[xtron]

I think you should look closer to dblink library. It's additional library to for example read data from other database, even if it's located on the different host.

[xtron]

Sample of use you can find :
your_postgresql _dir\doc\contri b\README.dblink

[anitajose]

Sample of use you can find :
your_postgresql _dir\doc\contri b\README.dblink

you can link 2 tables if both are in the same schema. Otherwise its not possible in postgresql.

[replicator]

I think you looking for REPLICATION.

I use SPAR http://coolese.100free.com/
It stands for Simple PostgreSQL Addon Replication.
Can keep 2 or more dB's aligned, so you can do normal SQL links on any of the dB's.

Nice FREE tool

Hi All,

I am wondering if there is a way to create a linked table in postgresql. I have a table in a DB i created and i want the table in a second DB, linked, so that any mods to one table apply to both.

Any help is appreciated.

[ahammond]

I think you looking for REPLICATION.

I use SPAR http://coolese.100free.com/
It stands for Simple PostgreSQL Addon Replication.
Can keep 2 or more dB's aligned, so you can do normal SQL links on any of the dB's.

Nice FREE tool

This implements statement based replication, which is fraught with problems. What you're asking for is synchronous, multi-master replication. The brief answer is Oracle RAC. It'll cost you in the millions. The other brief answer is that you probably don't need it.

If you describe the problem you're trying to solve, instead of the solution you think you've come up with, you're more likely to get a better answer.