Re: One table in two different databases

Perhaps:
dblink -
Allows remote query execution
by Joe Conway <mail(at)joeconway(dot)com>

This is under the contrib directory in your source distribution. I haven't done much with it, but it seems to allow access to tables not in the current database.

HTH,

Greg Williamson

-----Original Message-----
From: Marcelo Soares [mailto:msoares(at)masterhoteis(dot)com(dot)br]
Sent: Friday, August 08, 2003 6:17 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] One table in two different databases

Hi all,

I would like to know if its possible to have the SAME TABLE into two
different databases (but in the same server). Or to create a view of a
table of database X at the database Y.

I try to find it in Postgres docs, with no success.

Thanks to all,

Marcelo Soares
Informática - Master Hotéis
(51)3212-5055
ICQ Externo: 19398317
ICQ Interno: 1002

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match