expanded mode + wrapping in psql

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.

Responses

Browse pgsql-bugs by date

  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