Re: \l of psql 8.4 looks ... unreadable on 80char default

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
Cc: General Postgres Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: \l of psql 8.4 looks ... unreadable on 80char default
Date: 2009-02-19 13:22:30
Message-ID: 200902191322.n1JDMUn03322@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Harald Armin Massa wrote:
> postgres=# \pset format wrapped
> Ausgabeformat ist ?wrapped?.
> postgres=# \l
> Liste der Datenbanken
> Name | Eigent?mer | Kodierung | Collation | Ctype | Zug
> riffsrechte
> -----------+------------+-----------+-----------------+-----------------+-------
> ----------------
> ibox | ibox | UTF8 | German, Germany | German, Germany |
> postgres | postgres | UTF8 | German, Germany | German, Germany |
> template0 | postgres | UTF8 | German, Germany | German, Germany | =c/pos
> tgres
> : postgr
> es=CTc/postgres
> template1 | postgres | UTF8 | German, Germany | German, Germany | =c/pos
> tgres
> : postgr
> es=CTc/postgres
> (4 Zeilen)

What is your $COLUMNS set to? This should have wrapped to fit into the
screen with. Also look at \pset columns:

<quote>Wrapped</quote> is like <literal>aligned</> but wraps
output to the specified width. If <literal>\pset columns</> is
zero (the default), <literal>wrapped</> mode only affects screen
output and wrapped width is controlled by the environment
variable <envar>COLUMNS</> or the detected screen width. If
<literal>\pset columns</> is set to a non-zero value, all output
is wrapped, including file and pipe output.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2009-02-19 13:26:01 Re: Appending \o output instead of overwriting the output file
Previous Message Harald Armin Massa 2009-02-19 13:18:43 Re: \l of psql 8.4 looks ... unreadable on 80char default