expanded mode + wrapping in psql

Поиск
Список
Период
Сортировка
От Denis de Bernardy
Тема expanded mode + wrapping in psql
Дата
Msg-id 44085.8003.qm@web112413.mail.gq1.yahoo.com
обсуждение исходный текст
Ответы Re: expanded mode + wrapping in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: collation problem on 9.1-beta1
Следующее
От: "Luiz K. Matsumura"
Дата:
Сообщение: Behaviour of triggers on replicated and non replicated tables