Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Luiz K. MatsumuraDate: 2011-06-10 13:20:27
Subject: Behaviour of triggers on replicated and non replicated tables
Previous:From: Bruce MomjianDate: 2011-06-10 03:24:36
Subject: Re: collation problem on 9.1-beta1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group