Re: Change the current database programatically

-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200302181006

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

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