Re: help! default database for user

From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: philip johnson <philip(dot)johnson(at)atempo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: help! default database for user
Date: 2003-01-02 22:55:46
Message-ID: 3E14C372.7060407@intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

An extension of .bash_profile would be /etc/profile, a system wide point of
customization with a few line of code that export PGDATABASE based on
userid or
groupid or whatever ....

Martijn van Oosterhout wrote:

>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,
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2003-01-02 23:31:21 Re: pg_restore woes..
Previous Message Bruce Momjian 2003-01-02 22:47:25 Re: pg_restore woes..