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
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