Thread: help! default database for user
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 thanks in advance
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/ > Support bacteria! They're the only culture some people have.
Attachment
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, > >
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