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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
