Re: Query results display of text with leading spaces?

Поиск
Список
Период
Сортировка
От Aditya Toshniwal
Тема Re: Query results display of text with leading spaces?
Дата
Msg-id CAM9w-_mCtz9cHtJxU9=Pa3uTvpjEnyTRJwi_V=wReHduNwojvg@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jose Mercedes Venegas Acevedo
Дата:
Сообщение: Re: PREGUNTA
Следующее
От: Aditya Toshniwal
Дата:
Сообщение: Re: Query results display of text with leading spaces?