expanded mode + wrapping in psql - Mailing list pgsql-bugs

From Denis de Bernardy
Subject expanded mode + wrapping in psql
Date
Msg-id 44085.8003.qm@web112413.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: expanded mode + wrapping in psql
List pgsql-bugs
Wrapping apparently doesn't want to work in expanded mode...

Lengthier discussion here:

http://stackoverflow.com/questions/6306063/


test=3D# \t

Showing only tuples.
test=3D# \pset border 0
Border style is 0.
test=3D# \pset format wrapped
Output format is wrapped.
test=3D# \pset columns 20
Target width for "wrapped" format is 20.

This works as expected:

test=3D# select id, name from test;
=A02 abc abc abc abc .
=A0=A0 abc abc abc abc .
=A0=A0 abc abc abc abc .
=A0=A0 (etc.)

This doesn't:

test=3D# \x
Expanded display is on.
test=3D# select id, name from test;
id =A0 2
name abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc ab=
c abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc a=
bc abc abc abc=A0

Expected result would be more like this, since wrapping for a column-width =
of 20 was set:

test=3D# select id, name from test;
id =A0 2
name abc abc abc abc .
=A0=A0 =A0 =A0 =A0 abc abc abc abc .
=A0=A0 =A0 =A0 =A0 abc abc abc abc .
=A0=A0 =A0 =A0 =A0 (etc.)

D.

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: collation problem on 9.1-beta1
Next
From: "Luiz K. Matsumura"
Date:
Subject: Behaviour of triggers on replicated and non replicated tables