Horton

Re: Psql meta-command conninfo+

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Hunaid Sohail <hunaidpgml@gmail.com>
Cc: pgsql-hackers@postgresql.org, Sami Imseih <samimseih@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>, Maiquel Grassi <grassi@hotmail.com.br>, Jim Jones <jim.jones@uni-muenster.de>, Tom Lane <tgl@sss.pgh.pa.us>, Nathan Bossart <nathandbossart@gmail.com>, "Imseih (AWS), Sami" <simseih@amazon.com>, Peter Eisentraut <peter@eisentraut.org>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Erik Wienhold <ewie@ewie.name>, Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2025-01-16T13:01:44Z
Lists: pgsql-hackers 
On 2025-Jan-16, Hunaid Sohail wrote:

>  server_encoding               | UTF8
>  server_version                | 18devel
>  client_encoding               | UTF8
>  session_authorization         | hunaid
>  standard_conforming_strings   | on
>  DateStyle                     | ISO, MDY
>  scram_iterations              | 4096
>  default_transaction_read_only | off
>  application_name              | psql
>  is_superuser                  | on
>  search_path                   | "$user", public
>  IntervalStyle                 | postgres
>  TimeZone                      | Asia/Karachi
>  integer_datetimes             | on
>  in_hot_standby                | off

Wait a second, why do we have these here?  Aren't they already in
\dconfig?

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Having your biases confirmed independently is how scientific progress is
made, and hence made our great society what it is today" (Mary Gardiner)

Commits

  1. psql: Change new \conninfo to use SSL instead of TLS

  2. Change \conninfo to use tabular format

  3. Update extension lookup routines to use the syscache

  4. Improve COPY TO performance when server and client encodings match

  5. doc: Remove superfluous bracket in synopsis

  6. Remove psql support for server versions preceding 9.2.