Re: help! default database for user

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: philip johnson <philip(dot)johnson(at)atempo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: help! default database for user
Date: 2003-01-02 22:42:21
Message-ID: 20030102224221.GB26242@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 02, 2003 at 07:27:21PM +0100, philip johnson wrote:
>
> is it possible to assign a default database for a user
> example: database B for user A
>
> so when I will use psql it will not say thet database A does not
> exists

The easiest way I can think of is to set the PGDATABASE environment variable
in the .bash_profile of the user. then psql will use that instead of the
username.

HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-01-02 22:47:25 Re: pg_restore woes..
Previous Message Dan Langille 2003-01-02 21:21:18 Re: new project - PostgresSQL based voting script