Re: database name aliases?

From: "Talha Khan" <talha(dot)amjad(at)gmail(dot)com>
To: "Reece Hart" <reece(at)harts(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: database name aliases?
Date: 2006-11-06 23:54:10
Message-ID: f80885fc0611061554t15a2491bmb79ebfbbfc22bcf6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 <reece(at)harts(dot)net> 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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2006-11-07 00:29:33 Re: database name aliases?
Previous Message Reece Hart 2006-11-06 23:07:02 database name aliases?