Thread: Change the current database programatically

Is there any way to change the current database programatically?
We have a several databases structure, all of them postgreSQL db's and all
of them located at the same host.  I'm developing a function that must
retrieve data from different tables located at different databases. So, is
there anyway (at pl/pgsql level) to do that?

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Is there any way to change the current database programatically?
> ...
> So, is there anyway (at pl/pgsql level) to do that?

The short answer is "no". The databases are fairly well separated:
this is considered a Good Thing. What you want to use is schemas,
which are now available in version 7.3. This would be a great reason
to upgrade to 7.3.2 if you are not there already.

You also may want to look at "dblink" in the contrib directory,
which is probably the closest to what you want without using schemas.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200302181006

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+UkwZvJuQZxSWSsgRAtTuAJ9EbjhKITx7uU1p789bEA9NWgjNBQCdGoW/
XjyB42rn32fqsrJXhgZqHVY=
=bICC
-----END PGP SIGNATURE-----