pgAdmin Query tool output - wrap text

From: <harry(at)harryclarke(dot)me(dot)uk>
To: <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: pgAdmin Query tool output - wrap text
Date: 2023-10-13 09:55:35
Message-ID: 000001d9fdbb$69cb1990$3d614cb0$@harryclarke.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Normally I don't want to wrap text, but having imported a table containing a
column with a very long text string, this has become necessary. In Excel
"Wrap Text" can be implemented for individual columns, and in psql, the same
thing can be achieved by submitting a command in the form of:

SELECT id, Regexp_Replace(long_description, '(.{10,100}) ' , E'\\1\n' , 'g')
AS description FROM my_table;

In psql, the resulting output for each row is displayed on multiple lines,
with a column width of 100, split on spaced between words. However, if I
submit the same command in the Query tool of pgAdmin, the result is
displayed on one line per row.
Would it be possible to implement something similar in pgAdmin?

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message roo hink 2023-10-13 15:25:44 Can't run the app pgAdmin 4
Previous Message Andreas Laggner 2023-10-13 09:54:07 pgAdmin4 7.6 Server "Does not have clipboard access"