proposal: psql –help reflecting service or URI usage

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: proposal: psql –help reflecting service or URI usage
Date: 2021-02-28 09:57:32
Message-ID: DE74DF33-DD06-40FC-9899-1ECCBF3D1251@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I'd like to propose a patch to psql --help output:

Currently it is:

Usage:
psql [OPTION]... [DBNAME [USERNAME]]

...

Connection options:
-h, --host=HOSTNAME database server host or socket directory (default: "local socket")
-p, --port=PORT database server port (default: "5432")
-U, --username=USERNAME database user name (default: "paul")
-w, --no-password never prompt for password
-W, --password force password prompt (should happen automatically)

I'd like to change it to the following to reflect the psql ability to process a service name or a PostgreSQL URI:

Usage:
psql [OPTION]... [DBNAME [USERNAME]|service|uri]

...

Connection options:
-h, --host=HOSTNAME database server host or socket directory (default: "local socket")
-p, --port=PORT database server port (default: "5432")
-U, --username=USERNAME database user name (default: "paul")
-w, --no-password never prompt for password
-W, --password force password prompt (should happen automatically)
service=name service name as definited in pg_service.conf
uri connection URI (postgresql://...)

...

Attached is a patch for src/bin/psql/help.c for this. The file doc/src/sgml/ref/psql-ref.sgml does not seem to need any changes for this.

Any thoughts on this?

Attachment Content-Type Size
psql-help.c.patch application/octet-stream 1.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Jacobson 2021-02-28 11:15:51 Re: regexp_positions()
Previous Message David Rowley 2021-02-28 09:14:59 Re: Side effect of remove_useless_groupby_columns