pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSELECT with INNER data bases
3+ messages / 3 participants
[nested] [flat]
* SELECT with INNER data bases
@ 2002-10-10 12:37 2000 Informática <2000info@netsite.com.br>
2002-10-10 12:41 ` Re: SELECT with INNER data bases Bruno Wolff III <bruno@wolff.to>
2002-10-10 15:19 ` Re: SELECT with INNER data bases Roberto Mello <rmello@cc.usu.edu>
0 siblings, 2 replies; 3+ messages in thread
From: 2000 Informática @ 2002-10-10 12:37 UTC (permalink / raw)
To: 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>; pgsql-sql
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 !
Silvio
2000Info
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SELECT with INNER data bases
2002-10-10 12:37 SELECT with INNER data bases 2000 Informática <2000info@netsite.com.br>
@ 2002-10-10 12:41 ` Bruno Wolff III <bruno@wolff.to>
1 sibling, 0 replies; 3+ messages in thread
From: Bruno Wolff III @ 2002-10-10 12:41 UTC (permalink / raw)
To: 2000 Informática <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>; pgsql-sql
On Thu, Oct 10, 2002 at 09:37:49 -0300,
2000 Informática <2000info@netsite.com.br> 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 ?
Postgres does not allow for queries to reference more than one database.
In 7.3 (currently in beta), you may be able to use schemas to keep your
data in the same database and use queries referencing tables in different
schemas. Whether or not this will work for you depends on why you have
put the data into different databases.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SELECT with INNER data bases
2002-10-10 12:37 SELECT with INNER data bases 2000 Informática <2000info@netsite.com.br>
@ 2002-10-10 15:19 ` Roberto Mello <rmello@cc.usu.edu>
1 sibling, 0 replies; 3+ messages in thread
From: Roberto Mello @ 2002-10-10 15:19 UTC (permalink / raw)
To: 2000 Informática <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>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-10-10 15:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-10 12:37 SELECT with INNER data bases 2000 Informática <2000info@netsite.com.br>
2002-10-10 12:41 ` Bruno Wolff III <bruno@wolff.to>
2002-10-10 15:19 ` Roberto Mello <rmello@cc.usu.edu>
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