Received: from portal.inducola.com.br (inducola.creativenet.com.br [200.215.116.226]) by postgresql.org (8.11.3/8.11.4) with SMTP id f9J1ZsP00732 for ; Thu, 18 Oct 2001 21:36:12 -0400 (EDT) (envelope-from douglas@inducola.com.br) Received: (qmail 10233 invoked by uid 99); 18 Oct 2001 22:57:20 -0000 Received: from unknown (HELO inducola.com.br) (douglas@200.215.116.152) by portal.inducola.com.br with SMTP; 18 Oct 2001 22:57:20 -0000 Message-ID: <3BCF859C.D42C8895@inducola.com.br> Date: Thu, 18 Oct 2001 23:45:00 -0200 From: Douglas Rafael da Silva Reply-To: douglas@inducola.com.br Organization: Daune Produtos Industriais Ltda X-Mailer: Mozilla 4.73 [en] (X11; U; Linux 2.2.16 i686) X-Accept-Language: pt-BR, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Diferent databases on same query... Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/279 X-Sequence-Number: 5232 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 ? Thank you. Douglas Rafael.