Re: How to change the default database for a user

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to change the default database for a user
Date: 2006-01-30 18:18:02
Message-ID: 943abd910601301018y74231aa3ked421bbddc29d1a7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 1/30/06, Doug McNaught <doug(at)mcnaught(dot)org> wrote:
> Alexander Farber <alexander(dot)farber(at)gmail(dot)com> writes:
> > h754814:afarber {103} psql -U punbb
> > psql: FATAL: database "phpbb" does not exist
>
> psql uses your Unix username as the default database if you don't
> specify one.

but I do specify the database username:

h754814:afarber {109} psql --help | grep -w user
-U NAME database user name (default: "phpbb")

h754814:afarber {110} psql -U punbb
psql: FATAL: database "phpbb" does not exist

And it wants to connect to a wrong database
("phpbb" instead of "punbb")

Regards
Alex

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2006-01-30 18:40:33 Re: How to change the default database for a user
Previous Message Bruce Momjian 2006-01-30 18:13:27 Re: incremental backups