Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
Gregory, >> $COLUMNS was not set at all ... guess that is a usual >environment >> variable on bash. Setting it to 80 works. > > COLUMNS wasn't set and \pset columns wasn't set? What environment were you > running this psql command in? Was the output redirected anywhere with \o or > with > on the commandline? Environment: cmd.exe within Windows 7 Beta 64bit. (should be quite similar to Vista & XP) And I did not redirect anything ... Just started a default cmd.exe, to paste it into the email I used "select" and "copy" from the system-menu of that window. (this "\l" is just my "ritual" after installing PostgreSQL, to see that PostgreSQL is installed and the installer accepted my wish for UTF-8) > We had a long argument about how this should work a while back so I suspect > people aren't psyched about reopening it, but while I don't think the current > logic is right I don't think wrapping to 80 columns when your terminal is > wider is one of the current broken cases. It tends to fail in the opposite > direction of randomly not wrapping at all so it's kind of surprising to see > your experience. It did not wrap at all, so that "randomly not wrapping at all" was my kind of failure, wasn't it? Harald -- 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
Harald Armin Massa wrote: > Thanks! > > > What is your $COLUMNS set to? This should have wrapped to fit into the > > screen with. Also look at \pset columns: > > $COLUMNS was not set at all ... guess that is a usual environment > variable on bash. Setting it to 80 works. Great. The wrapping mode is a new 8.4 features so it os good to know it is working for you. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
Harald Armin Massa writes: > Thanks! > >> What is your $COLUMNS set to? This should have wrapped to fit into the >> screen with. Also look at \pset columns: > > $COLUMNS was not set at all ... guess that is a usual environment > variable on bash. Setting it to 80 works. COLUMNS wasn't set and \pset columns wasn't set? What environment were you running this psql command in? Was the output redirected anywhere with \o or with > on the commandline? We had a long argument about how this should work a while back so I suspect people aren't psyched about reopening it, but while I don't think the current logic is right I don't think wrapping to 80 columns when your terminal is wider is one of the current broken cases. It tends to fail in the opposite direction of randomly not wrapping at all so it's kind of surprising to see your experience. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
Thanks! > What is your $COLUMNS set to? This should have wrapped to fit into the > screen with. Also look at \pset columns: $COLUMNS was not set at all ... guess that is a usual environment variable on bash. Setting it to 80 works. Thank you very much, Harald -- 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
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: Wrapped is like aligned but wraps output to the specified width. If \pset columns is zero (the default), wrapped mode only affects screen output and wrapped width is controlled by the environment variable COLUMNS or the detected screen width. If \pset columns is set to a non-zero value, all output is wrapped, including file and pipe output. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] \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 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 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
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 http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] \l of psql 8.4 looks ... unreadable on 80char default
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. is this an effect only with "long name collations"? Harald -- 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general