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