Re: psql's default database on connect (our internal ref. SRP-30861)

Le ven. 6 août 2021 à 09:51, Matthias Apitz <guru(at)unixarea(dot)de> a écrit :

> El día viernes, agosto 06, 2021 a las 09:34:42a. m. +0200, Guillaume
> Lelarge escribió:
>
> > > No, it does not match all my examples. Read again what it says as
> > > default on --help.
> > >
> >
> > Actually, it does. You launched "psql --help" without specifying a
> > PostgreSQL username and database name, so it used your OS username as
> both
> > of them, hence the "default: testpos" for the database.
>
> Sorry, it does not:
>
> testpos(at)srap53dxr1:~> psql --help -Usisis | grep DBNAME
> psql [OPTION]... [DBNAME [USERNAME]]
> -d, --dbname=DBNAME database name to connect to (default: "testpos")
>

This wasn't in your first examples. I agree it's misleading. I guess this
happens because psql has no idea which database it will connect to in the
end. It isn't its call, but libpq's.