MIME-Version: 1.0
References: <Z4r_s1u61VLjO3xT@deb-M90>
In-Reply-To: <Z4r_s1u61VLjO3xT@deb-M90>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 17 Jan 2025 18:25:50 -0700
Message-ID: 
 <CAKFQuwY0MNcT3q8=S=bOvdQMnMUeGdHNYP8hMT7r7Cm=gb=bEg@mail.gmail.com>
Subject: Re: PG-15 - Format problems after jump migration from 9-4 to 15
To: pgsql-novice@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000008c129c062bf0eaa4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwY0MNcT3q8%3DS%3DbOvdQMnMUeGdHNYP8hMT7r7Cm%3Dgb%3DbEg%40mail.gmail.com>
Precedence: bulk

--0000000000008c129c062bf0eaa4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Jan 17, 2025 at 6:11=E2=80=AFPM Ennio-Sr <nasr.laili@tin.it> wrote:

> Could you please give me some hints to overcome the problem?
>
> =C2=A7=C2=A7--> And this is what appears on the screen when I enter 'mydb=
':
>
> usr@deby:~$ psql mydb
> Target width is 150.
> Output format is wrapped.
> psql (15.10 (Debian 15.10-0+deb12u1))
> Type "help" for help.
>
>
You are executing the corresponding \pset commands for those two options in
your .psqlrc file.  For scripts you generally don't want to do that. Either
modify your .psqlrc file, or pass -X to your psql command to ignore it.

Otherwise, those should be output on stdout; you can use your shell's tools
to send it elsewhere so your output capture doesn't see it.

Modifying "echo" output might also work.

David J.

--0000000000008c129c062bf0eaa4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Jan 17, 2025 at 6:11=E2=80=AFPM Ennio-Sr &lt;<a hr=
ef=3D"mailto:nasr.laili@tin.it">nasr.laili@tin.it</a>&gt; wrote:</span></di=
v></div><div class=3D"gmail_quote gmail_quote_container"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">Could you please give me some hints to ove=
rcome the problem?<br><br>
=C2=A7=C2=A7--&gt; And this is what appears on the screen when I enter &#39=
;mydb&#39;:<br>
<br>
usr@deby:~$ psql mydb<br>
Target width is 150.<br>
Output format is wrapped.<br>
psql (15.10 (Debian 15.10-0+deb12u1))<br>
Type &quot;help&quot; for help.<br><br></blockquote><div><br></div>You are =
executing the corresponding \pset commands for those two options in your .p=
sqlrc file.=C2=A0 For scripts you generally don&#39;t want to do that. Eith=
er modify your .psqlrc file, or pass -X to your psql <span class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">command=C2=A0</spa=
n>to ignore it.</div><div class=3D"gmail_quote gmail_quote_container"><br><=
/div><div class=3D"gmail_quote gmail_quote_container"><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">Otherwise, those s=
hould be output on stdout; you can use your shell&#39;s tools to send it el=
sewhere so your output capture doesn&#39;t see it.</div><div class=3D"gmail=
_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Mod=
ifying &quot;echo&quot; output might also work.</div><div class=3D"gmail_de=
fault" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div clas=
s=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David =
J.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,s=
ans-serif"><br></div></div></div>

--0000000000008c129c062bf0eaa4--