Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9JJZUP63935 for ; Fri, 19 Oct 2001 15:35:30 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f9JJ5sX54650 for pgsql-sql@postgresql.org; Fri, 19 Oct 2001 15:05:54 -0400 (EDT) (envelope-from news) From: "Andre Schnabel" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Diferent databases on same query... Date: Fri, 19 Oct 2001 21:05:44 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 28 Message-ID: <9qptih$1lbn$1@news.tht.net> References: <3BCF859C.D42C8895@inducola.com.br> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 To: pgsql-sql@postgresql.org X-Archive-Number: 200110/284 X-Sequence-Number: 5237 "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