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 |
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 |