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
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() |