help! default database for user

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@svana.org> http://svana.org/kleptog/

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:

pgsql-general-owner@postgresql.org wrote:

Objet : Re: [GENERAL] help! default database for user

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,

---------------------------(end of
broadcast)--------------------------- TIP 4: Don't 'kill -9' the
postmaster

thanks to all
It works great