By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,334 Members | 2,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,334 IT Pros & Developers. It's quick & easy.

Linking Tables from 2 databases

P: 1
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.
Jul 19 '06 #1
Share this Question
Share on Google+
5 Replies


P: 4
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.
Aug 2 '06 #2

P: 4
Sample of use you can find :
your_postgresql_dir\doc\contrib\README.dblink
Aug 2 '06 #3

P: 11
Sample of use you can find :
your_postgresql_dir\doc\contrib\README.dblink
you can link 2 tables if both are in the same schema. Otherwise its not possible in postgresql.
Sep 7 '06 #4

P: 1
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.
Jan 18 '07 #5

P: 7
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.
Jan 29 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.