From: | Denis de Bernardy <ddebernardy(at)yahoo(dot)com> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | expanded mode + wrapping in psql |
Date: | 2011-06-10 12:44:43 |
Message-ID: | 44085.8003.qm@web112413.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Wrapping apparently doesn't want to work in expanded mode...
Lengthier discussion here:
http://stackoverflow.com/questions/6306063/
test=# \t
Showing only tuples.
test=# \pset border 0
Border style is 0.
test=# \pset format wrapped
Output format is wrapped.
test=# \pset columns 20
Target width for "wrapped" format is 20.
This works as expected:
test=# select id, name from test;
2 abc abc abc abc .
abc abc abc abc .
abc abc abc abc .
(etc.)
This doesn't:
test=# \x
Expanded display is on.
test=# select id, name from test;
id 2
name abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc
Expected result would be more like this, since wrapping for a column-width of 20 was set:
test=# select id, name from test;
id 2
name abc abc abc abc .
abc abc abc abc .
abc abc abc abc .
(etc.)
D.
From | Date | Subject | |
---|---|---|---|
Next Message | Luiz K. Matsumura | 2011-06-10 13:20:27 | Behaviour of triggers on replicated and non replicated tables |
Previous Message | Bruce Momjian | 2011-06-10 03:24:36 | Re: collation problem on 9.1-beta1 |