Re: Change the current database programatically - Mailing list pgsql-novice

From greg@turnstep.com
Subject Re: Change the current database programatically
Date
Msg-id 471ae7fb0d81c2b716433309d00e71bf@biglumber.com
Whole thread Raw
In response to Change the current database programatically  ("guillermo schulman" <gsmiscel@hotmail.com>)
List pgsql-novice
-----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-----



pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Granting permission for users to create users...
Next
From: Steve_Miller@sil.org
Date:
Subject: Re: Multiple Return Values?