This is a discussion on Re: [despammed] Accessing objects over db-borders within the pgsql Sql forums, part of the PostgreSQL category; --> am 04.02.2005, um 12:00:17 +0100 mailte KÖPFERL Robert folgendes: > Hi, > > Consider one postmaster that manages multiple ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| am 04.02.2005, um 12:00:17 +0100 mailte KÖPFERL Robert folgendes: > Hi, > > Consider one postmaster that manages multiple databases (logical names) > > Is it possible (and how) to access a stored procedure or view/Table which > resides in DB aaa if your DB-connection has currently the context on DB bbb? Yes, take a look at dblink (contrib-package) Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend |