Select table from other database

From: "Tiago Moitinho" <tmoitinho(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Select table from other database
Date: 2002-10-21 10:54:53
Message-ID: F77FuXCpU6q5ijb1u2Z000007e0@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I would like to know if this is possible:

I have a database A, with a table X.
Is it possible, being logged in another database (B, for instance), to make
queries using table X from database A?
(something like "SELECT * FROM A.X ...")

Thanks in advance

Tiago

_________________________________________________________________
Get a speedy connection with MSN Broadband. Join now!
http://resourcecenter.msn.com/access/plans/freeactivation.asp

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jadcharla Srinivas 2002-10-21 13:41:44 Finding table constraints
Previous Message Richard Huxton 2002-10-21 10:13:57 Re: Can I search for an array in csf?