public inbox for [email protected]
help / color / mirror / Atom feeddisplaying line breaks / increasing row height in pgadmin
4+ messages / 4 participants
[nested] [flat]
* displaying line breaks / increasing row height in pgadmin
@ 2024-05-22 11:46 Luke Campbell <[email protected]>
2024-05-22 12:13 ` Re: displaying line breaks / increasing row height in pgadmin Erik Wienhold <[email protected]>
2024-05-22 12:56 ` Re: displaying line breaks / increasing row height in pgadmin Muhammad Salahuddin Manzoor <[email protected]>
2024-05-25 06:20 ` Re: displaying line breaks / increasing row height in pgadmin Usman Khan <[email protected]>
0 siblings, 3 replies; 4+ messages in thread
From: Luke Campbell @ 2024-05-22 11:46 UTC (permalink / raw)
To: [email protected]
Hi pgadmin maillist,
Is there a way to make the results grid in pgadmin automatically increase
rows' height if a string contains a carriage return?
I've updated pgadmin 4 to 8.6 and strings in the results grid now seem to
display line breaks / carriage returns by default, but this has caused me
to incorrectly think that was the end of the string. I would like these
strings to display as paragraphs or otherwise indicate that there's more
than what's displayed.
Yours,
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: displaying line breaks / increasing row height in pgadmin
2024-05-22 11:46 displaying line breaks / increasing row height in pgadmin Luke Campbell <[email protected]>
@ 2024-05-22 12:13 ` Erik Wienhold <[email protected]>
2 siblings, 0 replies; 4+ messages in thread
From: Erik Wienhold @ 2024-05-22 12:13 UTC (permalink / raw)
To: Luke Campbell <[email protected]>; +Cc: [email protected]
Hi Luke,
On 2024-05-22 13:46 +0200, Luke Campbell wrote:
> Is there a way to make the results grid in pgadmin automatically increase
> rows' height if a string contains a carriage return?
>
> I've updated pgadmin 4 to 8.6 and strings in the results grid now seem to
> display line breaks / carriage returns by default, but this has caused me
> to incorrectly think that was the end of the string. I would like these
> strings to display as paragraphs or otherwise indicate that there's more
> than what's displayed.
This list is only about Postgres administration. PgAdmin has a separate
list: https://www.postgresql.org/list/pgadmin-support/
--
Erik
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: displaying line breaks / increasing row height in pgadmin
2024-05-22 11:46 displaying line breaks / increasing row height in pgadmin Luke Campbell <[email protected]>
@ 2024-05-22 12:56 ` Muhammad Salahuddin Manzoor <[email protected]>
2 siblings, 0 replies; 4+ messages in thread
From: Muhammad Salahuddin Manzoor @ 2024-05-22 12:56 UTC (permalink / raw)
To: Luke Campbell <[email protected]>; +Cc: [email protected]
Dear Luke,
In pgAdmin 4, as of version 8.6, there is no direct setting to
automatically adjust the row height in the results grid to fit multiline
strings. However, you can use the following workarounds to better manage
the display of multiline text in your results grid.
Use the Cell Edit Panel:
Enable Word Wrap in the Query Tool:
Adjust Row Height Manually:
Custom Query Formatting:
External Tools:
*Salahuddin (살라후딘**)*
On Wed, 22 May 2024 at 16:47, Luke Campbell <[email protected]>
wrote:
> Hi pgadmin maillist,
>
> Is there a way to make the results grid in pgadmin automatically increase
> rows' height if a string contains a carriage return?
>
> I've updated pgadmin 4 to 8.6 and strings in the results grid now seem to
> display line breaks / carriage returns by default, but this has caused me
> to incorrectly think that was the end of the string. I would like these
> strings to display as paragraphs or otherwise indicate that there's more
> than what's displayed.
>
> Yours,
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: displaying line breaks / increasing row height in pgadmin
2024-05-22 11:46 displaying line breaks / increasing row height in pgadmin Luke Campbell <[email protected]>
@ 2024-05-25 06:20 ` Usman Khan <[email protected]>
2 siblings, 0 replies; 4+ messages in thread
From: Usman Khan @ 2024-05-25 06:20 UTC (permalink / raw)
To: Luke Campbell <[email protected]>; +Cc: [email protected]
Hi,
There seems no automatic way to achieve this in pgadmin 4 yet.
To cater the situation so that you do not miss any such output and get an
immediate clue that particular column or cell contain carriage return we
can tweak with the query a little like following (which replaces carriage
return with '\n')
SELECT REPLACE(your_column, E'\n', '\n') AS formatted_text
FROM your_table;
Additionally, any questions related to pgadmin 4 can directly be asked at
'pgadmin-hackers' for quick response.
Note: Removing psql-hackers and adding pgadmin-hackers in the mail list.
On Wed, May 22, 2024 at 4:47 PM Luke Campbell <[email protected]>
wrote:
> Hi pgadmin maillist,
>
> Is there a way to make the results grid in pgadmin automatically increase
> rows' height if a string contains a carriage return?
>
> I've updated pgadmin 4 to 8.6 and strings in the results grid now seem to
> display line breaks / carriage returns by default, but this has caused me
> to incorrectly think that was the end of the string. I would like these
> strings to display as paragraphs or otherwise indicate that there's more
> than what's displayed.
>
> Yours,
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-05-25 06:20 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-22 11:46 displaying line breaks / increasing row height in pgadmin Luke Campbell <[email protected]>
2024-05-22 12:13 ` Erik Wienhold <[email protected]>
2024-05-22 12:56 ` Muhammad Salahuddin Manzoor <[email protected]>
2024-05-25 06:20 ` Usman Khan <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox