Diferent databases on same query...

From: Douglas Rafael da Silva <douglas(at)inducola(dot)com(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Diferent databases on same query...
Date: 2001-10-19 01:45:00
Message-ID: 3BCF859C.D42C8895@inducola.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Database1, Result1(at)Database2 WHERE ...

But Who I can to do this on Postgresql ?

Thank you.

Douglas Rafael.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aasmund Midttun Godal 2001-10-19 01:51:18 Access to functions
Previous Message Tom Lane 2001-10-19 01:39:30 Re: index question