From: Roberto Mello <rmello@cc.usu.edu>
To: 2000 Informática <2000info@netsite.com.br>
Cc: pgsql Ludwig Lim <lud_nowhere_man@yahoo.com>
Cc: pgsql Laurette Cisneros <laurette@nextbus.com>
Cc: pgsql Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: PG SQL Mailim <pgsql-sql@postgresql.org>
Subject: Re: SELECT with INNER data bases
Date: Thu, 10 Oct 2002 09:19:59 -0600
Message-ID: <20021010151959.GE24541@cc.usu.edu> (raw)
In-Reply-To: <005101c27059$d970be00$0100a8c0@Info2000.com.br>
References: <005101c27059$d970be00$0100a8c0@Info2000.com.br>
On Thu, Oct 10, 2002 at 09:37:49AM -0300, 2000 Informática wrote:
> Hi,
>
> I have two data bases: db1 and db2.
> In MS SQL Server I can use
> 'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER JOIN db2..table2 T2
> ON T1.ID = T2.ID ...'.
>
> How I do it in the PosgreSQL ?
>
> HELP ME, PLEASE !
>
> Sorry,
> I'm a Brazilian and I don't speak and write English very well !
PostgreSQL doesn't allow this by default. You can use 7.3 and schemas as
as suggested, or use a loadable module called dblink with 7.2. dblink is
under the PostgreSQL contrib/ directory. See its documentation.
And here goes the same as above, but in Portuguese :)
O PostgreSQL não permite isso por padrão. Você pode usar 7.3 e schemas
como foi sugerido, ou usar um módulo chamado dblink com 7.2. Esse módulo
está no diretório contrib do PostgreSQL. Veja sua documentação.
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
But what can you do with it?
-- ubiquitous cry from Linux-user partner
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: rmello@cc.usu.edu, 2000info@netsite.com.br, lud_nowhere_man@yahoo.com, laurette@nextbus.com, ch@rodos.fzk.de, achill@matrix.gatewaynet.com
Subject: Re: SELECT with INNER data bases
In-Reply-To: <20021010151959.GE24541@cc.usu.edu>
* 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