pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: chrup@mac.com
To: Andre Schnabel <a_schnabel@t-online.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Diferent databases on same query...
Date: Fri, 19 Oct 2001 17:53:39 -0500
Message-ID: <22C9D178-C4E4-11D5-BBB1-003065C61C62@mac.com> (raw)
In-Reply-To: <9qptih$1lbn$1@news.tht.net>

Andre,

The only reason to have data for one query in different databases is if 
the databases are on different machines. If you're running on PC-type 
hardware, you might have to do that some times for performance reasons. 
But if at that point, you should ask yourself if you shouldn't invest in 
some faster hardware ;-).

Best regards (Tschüs),
Chris


On Friday, October 19, 2001, at 02:05 , Andre Schnabel wrote:

>
> "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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre




view thread (9+ messages)  latest in thread

Message-ID: <22C9D178-C4E4-11D5-BBB1-003065C61C62@mac.com>
Permalink:  ../22C9D178-C4E4-11D5-BBB1-003065C61C62@mac.com/
Also on:    postgresql.org/message-id/22C9D178-C4E4-11D5-BBB1-003065C61C62@mac.com

 · 

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: chrup@mac.com, a_schnabel@t-online.de
  Subject: Re: Diferent databases on same query...
  In-Reply-To: <22C9D178-C4E4-11D5-BBB1-003065C61C62@mac.com>

* 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