Re: How to change the default database for a user

Hi,

On 1/30/06, Doug McNaught <doug@mcnaught.org> wrote:
> Alexander Farber <alexander.farber@gmail.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