Link tables from different databases - Mailing list pgsql-general

From Reuben D. Budiardja
Subject Link tables from different databases
Date
Msg-id 200805172251.39897.techlist@pathfinder.phys.utk.edu
Whole thread Raw
Responses Re: Link tables from different databases  (Shane Ambler <pgsql@Sheeky.Biz>)
List 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

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: pg_standby stuck on a wal file size <16MB
Next
From: Greg Smith
Date:
Subject: Re: pg_standby stuck on a wal file size <16MB