| 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: | Whole Thread | Raw Message | 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?
| 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" |