expanded mode + wrapping in psql

Started by Denis de Bernardyalmost 15 years ago2 messagesbugs
Jump to latest
#1Denis de Bernardy
ddebernardy@yahoo.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Denis de Bernardy (#1)
Re: expanded mode + wrapping in psql

Denis de Bernardy <ddebernardy@yahoo.com> writes:

Wrapping apparently doesn't want to work in expanded mode...

No, it's not supposed to.

regards, tom lane