ewaters / altsql-shell

An easily extensible DBI shell, perfect for a drop-in replacement to mysql-client
http://ewaters.github.com/altsql-shell
123 stars 19 forks source link

Differentiate cell padding from string data #19

Open ewaters opened 12 years ago

ewaters commented 12 years ago

Have some visual way of seeing the width of the data in each column.

altsql> select film_id, title from film limit 5;
.---------+------------------.
| film_id | title            |
+---------+------------------+
|       1 | ACADEMY DINOSAUR |
|       2 | ACE GOLDFINGER   |
|       3 | ADAPTATION HOLES |
|       4 | AFFAIR PREJUDICE |
|       5 | AFRICAN EGG      |
'---------+------------------'

In the above example, it's entirely unclear if the 2nd or 5th rows have extra spaces at the end of the title. This rendering would be identical if the title for 5 was AFRICAN EGG<sp><sp> or AFRICAN EGG or AFRICAN EGG<sp>