Re: Unicode UTF-8 table formatting for psql text output

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Roger Leigh <rleigh@codelibre.net>
Cc: Robert Haas <robertmhaas@gmail.com>, Roger Leigh <rleigh@debian.org>, pgsql-hackers@postgresql.org
Date: 2009-08-26T02:32:50Z
Lists: pgsql-hackers
Roger Leigh escribió:

> An updated copy of the patch is attached.

I give it a try.  It looks very reasonable.  We could argue about the
exact chars to use but that can be changed later.

Did you give expanded output a look?  (\x)  I find it a bit weird that
the first line shows a single-pixel wide line but the subsequent ones
are thicker.

BTW I think you should also look at multiline fields,

 a │                                           b                                           
━━━┿━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 4 │ some text
   : and some more
   : and then some
(1 filas)

And wrapped:

alvherre=# select * from foo;
 a │                                     b                                      
━━━┿━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
 5 │ En un lugar de la Mancha, de cuyo nombre no quiero acordarme, no ha mucho 
   ; tiempo que vivía un hidalgo
(1 fila)


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support