You can do this by using a script. I mean whenever you are creating a new version of the database. you can do that by running a script that creates a database and then stores the name of that database in an environmental variable . Now you can run psql by connecting to a database through that variable.
Regards
Talha Khan
On 11/7/06, Reece Hart <reece@xxxxxxxxx> wrote:
I'd like to be able to have several versions of a database available concurrently and one database alias that refers to the most recent of these. For example:
dbname_1-1
dbname_1-2
dbname_1-3
dbname -> dbname_1-3
and
$ psql -d dbname
would connect to dbname_1-3.
Any ideas?
Thanks,
Reece
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
