Thread: Select table from other database

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

On Mon, Oct 21, 2002 at 11:54:53AM +0100, Tiago Moitinho wrote:
> 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 ...")

See the dblink module in the PostgreSQL contrib tree (available via ftp.
packages available).

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
Sigh.  I like to think it's just the Linux people who want to be on
the "leading edge" so bad they walk right off the precipice.-- Craig E. Groeschel