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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: psql's default database on connect (our internal ref. SRP-30861)
Date: 2021-08-06 13:50:34
Message-ID: 2477879.1628257834@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matthias Apitz <guru(at)unixarea(dot)de> writes:
> 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")

While that's certainly confusing, I'm not sure it's wrong.
I'd interpret "default" as meaning "default if you don't specify
something different on the command line". The default username
is reported under similar rules:

$ psql --help -Ufoo | grep user
-U, --username=USERNAME database user name (default: "tgl")

In any case, these choices of default have stood for a very long
time and we're unlikely to consider changing them. If (some parts
of) the docs are inaccurate we should change the docs.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2021-08-06 15:57:51 Re: sort order
Previous Message Ehtesham Pradhan 2021-08-06 09:08:58 TLS 1.0