Date: Sat, 18 Jan 2025 16:58:49 +0100
From: Ennio-Sr <nasr.laili@tin.it>
To: pgsql-novice@lists.postgresql.org, pgsql-novice@postgresql.org
Subject: Re: PG-15 - Format problems after jump migration from 9-4 to 15
Message-ID: <Z4vPuSO_trk8T3fm@deb-M90>
Reply-To: pgsql-novice@postgresql.org
Mail-Followup-To: pgsql-novice@postgresql.org,
	pgsql-novice@lists.postgresql.org
References: <Z4r_s1u61VLjO3xT@deb-M90>
 <CAKFQuwY0MNcT3q8=S=bOvdQMnMUeGdHNYP8hMT7r7Cm=gb=bEg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAKFQuwY0MNcT3q8=S=bOvdQMnMUeGdHNYP8hMT7r7Cm=gb=bEg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/Z4vPuSO_trk8T3fm%40deb-M90>
Precedence: bulk

* David G. Johnston <david.g.johnston@gmail.com> [170125, 18:25]:
> On Fri, Jan 17, 2025 at 6:11 PM Ennio-Sr <nasr.laili@tin.it> wrote:
> 
> > Could you please give me some hints to overcome the problem?
> >
> > §§--> 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.

First of all let me say 'Thank you very much indeed, David, for your help!
It saved ne time, which is becoming more and more precious to me'.

That said, I wonder reading what I could have gasped the answer: I
was using (in PG-15) the same settings I had set - more than 10 years ago
- in PG-9.4, and the troublesome script still works perfectly on my ald PC
  (both, PC and Beelink are running the same Debian version, as shown by
  <# uname -a>).

Thanks again, and I wish you all a wonderful 2025!

     ennio
-- 
[Perché usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.  \\?//
 Fà qualche cosa di cui non sei capace!"  (diceva Henry Miller)	    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.	    .)=(. 
 Do something you aren't good at!" (as Henry Miller used to say)]  /_____\