am 07.12.2005, um 8:18:45 +0000 mailte Robert Wimmer folgendes:
> is there any possibility in plpgsql (or from the psql prompt) to retrive
> data from any other PG database. if not is there a (recommended) work
> around for this problem.
You can use dblink (conntrib) or languages like plpgperl to connect to
multiple db.
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/
A better way is to use only one DB and using schemas.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===