Re: How to change the default database for a user

Argh, I had "phpbb" in my env ( ~/.login) too:

setenv  PGDATA          /var/postgresql/data
setenv  PGDATABASE      phpbb
setenv  PGHOST          /var/www/tmp
setenv  PGUSER          phpbb

Now everything makes sense (I was thinking
about some kind of system table for default databases).

Sorry and thank you for your help

Regards
Alex


On 1/30/06, Doug McNaught  wrote:
> I was talking about the name of the database, not the user name in the
> database.  The former defaults to the same as your Unix username
> (e.g. if I log in as 'doug' psql will try to connect me to a database
> called 'doug' if I don't supply a database name).  The PGDATABASE
> environment variable overrides this.  Are you sure it's not set?
>
> Anyway, you should always supply the database name explicitly when you
> connect--it's a lot safer.