Thread: Cross-database references
Someone knows how is going the implementation of cross database references in pgsql ?
Would have some future release with this great functionality ?
Thanks,
Pedro Igor
On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the implementation of cross database referencesin pgsql ? > Would have some future release with this great functionality ? This is usually left up to the front-end. Usually for me, perl DBI. This way, I can connect to multiple databases, possibly all of different types (PgSQL, Oracle, Informix, ...). I'm sure the SQL gurus can corret me, but I was under the impression that cross-database references in the backend would be capital-D Difficult to implement with transaction support. Then there's the further tearing asunder of the ANSI SQL standard... Jason -- Indigo Industrial Controls Ltd. 64-21-343-545 jasont@indigoindustrial.co.nz
On Tue, Jan 28, 2003 at 05:30:06PM -0200, Pedro Igor Craveiro e Silva wrote: > AIP - Assessoria Informática e Proteção LTDASomeone knows how is going the implementation of cross database referencesin pgsql ? > Would have some future release with this great functionality ? Olá Pedro, Look at the dblink module under the contrib section of PostgreSQL. It implements the feature you're looking for. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + "There's 2 kind of people: those who knows assembler and the rest"