Perhaps:
dblink -
Allows remote query execution
by Joe Conway <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 6:17 PM
To: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
