Perhaps:
dblink -
Allows remote query execution
by Joe Conway <mail@joeconway.com>
This is under the contrib directory in your source distribution. I haven't done much with it, but it seems to allow
accessto tables not in the current database.
HTH,
Greg Williamson
-----Original Message-----
From: Marcelo Soares [mailto:msoares@masterhoteis.com.br]
Sent: Friday, August 08, 2003 6:17 PM
To: pgsql-general@postgresql.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