Horton

Re: psql --help=variables missing csv_fieldsep

Álvaro Herrera <alvherre@kurilemu.de>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@kurilemu.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>, Daniel Verite <daniel@manitou-mail.org>
Date: 2025-11-03T20:20:28Z
Lists: pgsql-hackers 
On 2025-Nov-03, Tom Lane wrote:

> =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.de> writes:
> > While messing with the \pset boolean display patch, I noticed that psql
> > --help=variables is missing csv_fieldsep.  Is there a reason for this?
> 
> But wait ... is it actually a variable?  help.c does list it, but
> as a \pset option:
> 
>     HELP0("  \\pset [NAME [VALUE]]   set table output option\n"
>           "                         (border|columns|csv_fieldsep|display_false|display_true|\n"

Yeah, there are two lists: one here in the "\?" output, and another in
the "\? variables" output, which is also `psql --help=variables`.  It
lists actual variables but also \pset options and environment variables
psql recognizes.  I find this one you quote somewhat unreadable, so I
was going to propose to remove it, and instead direct the user to look
at "\?  variables" for the exhaustive list.  That one is also a bit
easier to cross-check, I think.  (There's also tab-complete.)

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"No renuncies a nada. No te aferres a nada."

Commits

  1. Refer readers of \? to "\? variables" for pset options

  2. Have psql's "\? variables" show csv_fieldsep

  3. Add CSV table output mode in psql.