Re: Query results display of text with leading spaces?

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(at)sopchak(dot)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*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"