Received: from smtpout.mac.com (smtpout.mac.com [204.179.120.88]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9JMrmP01114 for ; Fri, 19 Oct 2001 18:53:49 -0400 (EDT) (envelope-from chrup@mac.com) Received: from smtp-relay01.mac.com (smtp-relay01-qfe3 [10.13.10.224]) by smtpout.mac.com (8.10.2/8.10.2/1.0) with ESMTP id f9JMrcV17425 for ; Fri, 19 Oct 2001 15:53:38 -0700 (PDT) Received: from asmtp02.mac.com ([10.13.10.66]) by smtp-relay01.mac.com (Netscape Messaging Server 4.15 relay01 Jun 21 2001 23:53:48) with ESMTP id GLH69G00.VW3 for ; Fri, 19 Oct 2001 15:53:40 -0700 Received: from localhost ([24.219.2.25]) by asmtp02.mac.com (Netscape Messaging Server 4.15 asmtp02 Jun 21 2001 23:53:48) with ESMTP id GLH69G00.T13; Fri, 19 Oct 2001 15:53:40 -0700 Date: Fri, 19 Oct 2001 17:53:39 -0500 Subject: Re: Diferent databases on same query... Content-Type: text/plain; charset=ISO-8859-1; format=flowed Mime-Version: 1.0 (Apple Message framework v472) Cc: pgsql-sql@postgresql.org To: "Andre Schnabel" From: chrup@mac.com In-Reply-To: <9qptih$1lbn$1@news.tht.net> Message-Id: <22C9D178-C4E4-11D5-BBB1-003065C61C62@mac.com> X-Mailer: Apple Mail (2.472) Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9JNAZM04955 X-Archive-Number: 200110/312 X-Sequence-Number: 5265 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" 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