MIME-Version: 1.0
References: 
 <CAEnhCyZHfV8MQ4iBBYr46HNDGDaHvDoUStA6JCk=nRGG=3+SFA@mail.gmail.com>
In-Reply-To: 
 <CAEnhCyZHfV8MQ4iBBYr46HNDGDaHvDoUStA6JCk=nRGG=3+SFA@mail.gmail.com>
From: Usman Khan <umk555@gmail.com>
Date: Sat, 25 May 2024 11:20:55 +0500
Message-ID: 
 <CANVC+RHvgYMedJQZ_LLoEdvqm=ToojePyQdBqQSWEJPn3s2tZw@mail.gmail.com>
Subject: Re: displaying line breaks / increasing row height in pgadmin
To: Luke Campbell <lukejcampbell7@gmail.com>
Cc: pgadmin-hackers@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f7200206194149f1"
Archived-At: 
 <https://www.postgresql.org/message-id/CANVC%2BRHvgYMedJQZ_LLoEdvqm%3DToojePyQdBqQSWEJPn3s2tZw%40mail.gmail.com>
Precedence: bulk

--000000000000f7200206194149f1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Luke Campbell <lukejcampbell7@gmail=
.com>
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,
>

--000000000000f7200206194149f1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div>There seems no automatic way to achieve=
 this in pgadmin 4 yet.</div><div><br></div><div>To cater the situation so =
that you do not miss any such output and get an immediate clue that particu=
lar column or cell contain carriage return we can tweak with the query a li=
ttle like following (which replaces carriage return with &#39;\n&#39;)<br><=
/div><div><br></div><div>SELECT REPLACE(your_column, E&#39;\n&#39;, &#39;\n=
&#39;) AS formatted_text<br>FROM your_table;</div><div><br></div><div>Addit=
ionally, any questions related to pgadmin 4 can directly be asked at &#39;p=
gadmin-hackers&#39; for quick response.</div><div><br></div><div>Note: Remo=
ving psql-hackers and adding pgadmin-hackers in the mail list.<br></div></d=
iv><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On =
Wed, May 22, 2024 at 4:47=E2=80=AFPM Luke Campbell &lt;<a href=3D"mailto:lu=
kejcampbell7@gmail.com" target=3D"_blank">lukejcampbell7@gmail.com</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><div>Hi pgadmin maillist,</div><div><br></div><div>Is there a way =
to make the results grid in pgadmin automatically increase rows&#39; height=
 if a string contains a carriage return?</div><div><br></div><div>I&#39;ve =
updated pgadmin 4 to 8.6 and strings in the results grid now seem to displa=
y line breaks / carriage returns by default, but this has caused me to inco=
rrectly think that was the end of the string. I would like these strings to=
 display as paragraphs or otherwise indicate that there&#39;s more than wha=
t&#39;s displayed.<br></div><div><br></div><div>Yours,<br></div></div>
</blockquote></div>

--000000000000f7200206194149f1--