Link tables from different databases

From: "Reuben D(dot) Budiardja" <techlist(at)pathfinder(dot)phys(dot)utk(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Link tables from different databases
Date: 2008-05-18 02:51:39
Message-ID: 200805172251.39897.techlist@pathfinder.phys.utk.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
Suppose I have two tables db1.table1 and db2.table2. Is there anyway I can
actually have db2.table2 a link to db1.table1 ? What I meant is similar to a
symlink in Unix filesystem (db2.table2 is a symlink to db1.table1).

I want it so that every operation on db1.table1 (ie. INSERT, UPDATE, DELETE)
also happens to db2.table2, but similarly I want it that application can do
those operations on db2.table2 but actually it does it on db1.table1 behind
the scene.

Is there anything like this in postgresql ? I am using version 7.4 by the way.

Thanks in advance for any help.
RDB
--
Reuben D. Budiardja

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-05-18 04:37:46 Re: pg_standby stuck on a wal file size <16MB
Previous Message Gurjeet Singh 2008-05-18 02:39:46 Re: pg_standby stuck on a wal file size <16MB