Date: Thu, 10 Oct 2002 09:19:59 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: 2000 =?iso-8859-1?Q?Inform=E1tica?= <2000info@netsite.com.br>
Cc: pgsql Ludwig Lim <lud_nowhere_man@yahoo.com>,
	pgsql Laurette Cisneros <laurette@nextbus.com>,
	pgsql Christoph Haller <ch@rodos.fzk.de>,
	pgsql Achilleus Mantzios <achill@matrix.gatewaynet.com>,
	PG SQL Mailim <pgsql-sql@postgresql.org>
Subject: Re: SELECT with INNER data bases
Message-ID: <20021010151959.GE24541@cc.usu.edu>
References: <005101c27059$d970be00$0100a8c0@Info2000.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <005101c27059$d970be00$0100a8c0@Info2000.com.br>
User-Agent: Mutt/1.4i

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