Re: database name aliases? - Mailing list pgsql-general

From Talha Khan
Subject Re: database name aliases?
Date
Msg-id [email protected]
Whole thread Raw
In response to database name aliases?  (Reece Hart <[email protected]>)
Responses Re: database name aliases?
List pgsql-general
Hi Reece,

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 <[email protected]> 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


pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: database name aliases?
Next
From: Reece Hart
Date:
Subject: Re: database name aliases?