Content-Type: multipart/alternative;
 boundary="------------zh3Ql0Ck3ZG6ZqeI0jbTJBOq"
Message-ID: <2bb947f2-fb20-4c9b-b71b-db2eab372f96@postgrespro.ru>
Date: Thu, 10 Apr 2025 22:03:19 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: psql meta command
To: Marc Millas <marc.millas@mokadb.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CADX_1aZOLCixPFOH3f_QXpopQg6LhmG8aVhhik7Fg=3SnLKa4Q@mail.gmail.com>
Content-Language: en-US, ru-RU
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
In-Reply-To: <CADX_1aZOLCixPFOH3f_QXpopQg6LhmG8aVhhik7Fg=3SnLKa4Q@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/2bb947f2-fb20-4c9b-b71b-db2eab372f96%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------zh3Ql0Ck3ZG6ZqeI0jbTJBOq
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 10.04.2025 15:29, Marc Millas wrote:
> on a customer postgres db, using psql, if I post \  to initiate, for 
> exemple \x
> that psql immediately exits.
> somewhat boring as it blocks all psql meta commands.
> Is there a way to get the extended display without posting a \  ?

You can enable extended output when starting psql:

$ psql -x -c 'select 1,2,3'
-[ RECORD 1 ]
?column? | 1
?column? | 2
?column? | 3

Also, not sure but you can try hide \ in psql variable:

$ psql --set expanded_mode='\x'
psql (18devel)
Type "help" for help.

postgres@demo(18.0)=# :expanded_mode
Expanded display is on.
postgres@demo(18.0)=# select 1,2,3;
-[ RECORD 1 ]
?column? | 1
?column? | 2
?column? | 3

-- 
Pavel Luzanov
Postgres Professional:https://postgrespro.com

--------------zh3Ql0Ck3ZG6ZqeI0jbTJBOq
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    On 10.04.2025 15:29, Marc Millas wrote:<br>
    <blockquote type="cite"
cite="mid:CADX_1aZOLCixPFOH3f_QXpopQg6LhmG8aVhhik7Fg=3SnLKa4Q@mail.gmail.com">
      <div dir="ltr">
        <div>on a customer postgres db, using psql, if I post \  to
          initiate, for exemple \x</div>
        <div>that psql immediately exits.</div>
        <div>somewhat boring as it blocks all psql meta commands.</div>
        <div>Is there a way to get the extended display without posting
          a \  ?</div>
      </div>
    </blockquote>
    <br>
    <pre>You can enable extended output when starting psql:</pre>
    <pre>$ psql -x -c 'select 1,2,3'
-[ RECORD 1 ]
?column? | 1
?column? | 2
?column? | 3

Also, not sure but you can try hide \ in psql variable:

$ psql --set expanded_mode='\x'
psql (18devel)
Type "help" for help.

postgres@demo(18.0)=# :expanded_mode
Expanded display is on.
postgres@demo(18.0)=# select 1,2,3;
-[ RECORD 1 ]
?column? | 1
?column? | 2
?column? | 3

</pre>
    <pre class="moz-signature" cols="72">-- 
Pavel Luzanov
Postgres Professional: <a class="moz-txt-link-freetext" href="https://postgrespro.com">https://postgrespro.com</a></pre>
  </body>
</html>

--------------zh3Ql0Ck3ZG6ZqeI0jbTJBOq--