Re: SELECT with INNER data bases

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: 2000 Informática <2000info(at)netsite(dot)com(dot)br>
Cc: pgsql Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>, pgsql Laurette Cisneros <laurette(at)nextbus(dot)com>, pgsql Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, PG SQL Mailim <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SELECT with INNER data bases
Date: 2002-10-10 15:19:59
Message-ID: 20021010151959.GE24541@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Luis Mix 2002-10-10 19:14:04
Previous Message John Duffy 2002-10-10 15:17:40 NOTICE: generated by sequence nextval()