El jue, 09-08-2007 a las 15:08 -0400, Chris Hoover escribió: > On 8/8/07, Michael Goldner <MGoldner@xxxxxxxxxxxx> wrote: > Is it possible to access tables in two different databases, > running on the > same server, from within psql? > yes it is, with dblink. follow next link: http://www.postgresql.org/docs/faqs.FAQ.html 4.17) How do I perform queries using multiple databases? There is no way to query a database other than the current one. Because PostgreSQL loads database-specific system catalogs, it is uncertain how a cross-database query should even behave. contrib/dblink allows cross-database queries using function calls. Of course, a client can also make simultaneous connections to different databases and merge the results on the client side. > > > Take a look at dblink in the contrib area. I think it will give you > what you are looking for. > > Chris -- Regards, Julio Cesar Sánchez González www.sistemasyconectividad.com.mx blog: http://darkavngr.blogspot.com --- Ahora me he convertido en la muerte, destructora de mundos. Soy la Muerte que se lleva todo, la fuente de las cosas que vendran. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
