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

No difference at all. Line breaks are exactly as on screen (looks more
crazy in email with non-fixed-with font)
But really, linebreak betwwen "Zug" and "riffsrechte", and cutting
between "=c/pos" and "tgres"

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)

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)

Harald

On Thu, Feb 19, 2009 at 14:11, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Harald Armin Massa wrote:
>> Hello,
>>
>> testing / using PostgreSQL 8.4, I queried the list of databases via
>>
>> \l in psql
>>
>> I get information about name, owner, coding, Collation, Ctype and
>> access rights. Which wraps right in the middle of "ctype", as
>> collation and ctype both are "German, Germany"
>>
>> As a result: this basic information command is rather unreadable with
>> only 80chars.
>
> You might try the new psql option:
>
> \pset format wrapped
>
> to see if it looks better.
>
> --
> 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. +
>

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!