Re: Query results display of text with leading spaces? - Mailing list pgadmin-support

From Aditya Toshniwal
Subject Re: Query results display of text with leading spaces?
Date
Msg-id CAM9w-_mCtz9cHtJxU9=Pa3uTvpjEnyTRJwi_V=wReHduNwojvg@mail.gmail.com
Whole thread Raw
List pgadmin-support
Hi Carl,

It is difficult to understand what is expected. If you can explain with some screenshots then that would be helpful.

On Mon, Jan 30, 2023 at 2:22 AM Carl Sopchak <carl@sopchak.me> wrote:

It appears to me that text columns of a query result with leading spaces in a text column have the leading spaces stripped in the query tool's Data Output tab.  When I copy/paste a cell's value into a text editor it shows the leading spaces.  How do I get pgAdmin to not fully left justify the value upon display?  My purpose is an effort to add commas to an integer value to make it easier to read, but keeping the value right-justified in the column displayed so place digits align (although I can envision many other uses where leading spaces would be significant).

How can I do that?  Is it a font issue (how do I change the font?), or is it something pgAdmin is doing upon display (can it be turned off?)?

pgAdmin4 6.19 on Fedora Linux 37 (fully up-to-date).  I tried searching the archives ("leading spaces" among others) but came up empty...

Thanks for the help,

Carl



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

pgadmin-support by date:

Previous
From: Jose Mercedes Venegas Acevedo
Date:
Subject: Re: PREGUNTA
Next
From: Aditya Toshniwal
Date:
Subject: Re: Query results display of text with leading spaces?