Обсуждение: expanded mode + wrapping in psql

Поиск
Список
Период
Сортировка

expanded mode + wrapping in psql

От
Denis de Bernardy
Дата:
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.

Re: expanded mode + wrapping in psql

От
Tom Lane
Дата:
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