pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andre Schnabel <a_schnabel@t-online.de>
To: pgsql-sql@postgresql.org
Subject: Re: Diferent databases on same query...
Date: Fri, 19 Oct 2001 21:05:44 +0200
Message-ID: <9qptih$1lbn$1@news.tht.net> (raw)
References: <3BCF859C.D42C8895@inducola.com.br>


"Douglas Rafael da Silva" <douglas@inducola.com.br> schrieb im Newsbeitrag
news:3BCF859C.D42C8895@inducola.com.br...
> 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 ?
>

You CANNOT do that with PostgreSQL.
But why do you want to do that? IMHO it's a rather bas design to hold data
in different places, if you need to select them in one query.
Is there a real reason to hold the tables in different databases?

Andre





view thread (9+ messages)  latest in thread

Message-ID: <9qptih$1lbn$1@news.tht.net>
Permalink:  ../9qptih$1lbn$1@news.tht.net/
Also on:    postgresql.org/message-id/9qptih$1lbn$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: a_schnabel@t-online.de
  Subject: Re: Diferent databases on same query...
  In-Reply-To: <9qptih$1lbn$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox