Diferent databases on same query... - Mailing list pgsql-sql

From Douglas Rafael da Silva
Subject Diferent databases on same query...
Date
Msg-id 3BCF859C.D42C8895@inducola.com.br
Whole thread Raw
List pgsql-sql
Hi,

I'd like to do a query where can be possible I access tables from
diferent databases on the same query.
On MySQL, I do:

SELECT People1.PersID, People1.Name, Result1.Value, Result1.Date FROM
Database1.People1, Database2.Result1 WHERE ...

I think on ORACLE works like as:

SELECT People1.PersID, People1.Name, Result1.Value, Result1.Date FROM
People1@Database1, Result1@Database2 WHERE ...

But Who I can to do this on Postgresql ?

Thank you.

Douglas Rafael.


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: oid's in views.
Next
From: "Stefan Lindner"
Date:
Subject: system maintained keys