On Wed, Jun 19, 2024 at 5:16 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
>
> You hallucinated a dash in front of the bustrac. psql bustract is a
> perfectly valid psql command. User gets inferred from the OS user.
As in?:
psql -d test -U postgres bustrac
Well no, that is the specification of -U is the exact opposite of "user gets inferred from the OS user".
psql: warning: extra command-line argument "bustrac" ignored
psql (16.3 (Ubuntu 16.3-1.pgdg22.04+1), server 15.7 (Ubuntu
15.7-1.pgdg22.04+1))
Type "help" for help.
test=#
In which case bustrac is ignored.
You are missing the fact that bustrac is the name of the database so when you specify the -d option you are being redundant and being told that by psql.
psql [option...] [dbname [username]]
You like to specify both dbname and username via options but as shown one can also use arguments.
David J.
