Re: proposal (9.5) : psql unicode border line styles
| От | Pavel Stehule |
|---|---|
| Тема | Re: proposal (9.5) : psql unicode border line styles |
| Дата | |
| Msg-id | CAFj8pRDtbFgFRE2Vc2S5rog-pZmc-U1Z+bdw0kmOcEM_MDzfuw@mail.gmail.com обсуждение исходный текст |
| Ответ на | proposal (9.5) : psql unicode border line styles (Pavel Stehule <pavel.stehule@gmail.com>) |
| Ответы |
Re: proposal (9.5) : psql unicode border line styles
(Pavel Stehule <pavel.stehule@gmail.com>)
|
| Список | pgsql-hackers |
Hello
I had to reduce allowed line style to single or double, because unicode allows only combination single,double or single,thickpostgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
postgres=# \pset border 2
Border style (border) is 2.
postgres=# \pset linestyle unicode
Line style (linestyle) is unicode.
postgres=# \l
List of databases
┌───────────┬──────────┬──────────┬─────────────┬─────────────┬───────────────────────┐
│ Name │ Owner │ Encoding │ Collate │ Ctype │ Access privileges │
├───────────┼──────────┼──────────┼─────────────┼─────────────┼───────────────────────┤
│ postgres │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ │
│ template0 │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ =c/postgres ↵│
│ │ │ │ │ │ postgres=CTc/postgres │
│ template1 │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ =c/postgres ↵│
│ │ │ │ │ │ postgres=CTc/postgres │
└───────────┴──────────┴──────────┴─────────────┴─────────────┴───────────────────────┘
(3 rows)
postgres=# \pset unicode_header_linestyle double
Unicode border linestyle is "double".
postgres=# \l
List of databases
┌───────────┬──────────┬──────────┬─────────────┬─────────────┬───────────────────────┐
│ Name │ Owner │ Encoding │ Collate │ Ctype │ Access privileges │
╞═══════════╪══════════╪══════════╪═════════════╪═════════════╪═══════════════════════╡
│ postgres │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ │
│ template0 │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ =c/postgres ↵│
│ │ │ │ │ │ postgres=CTc/postgres │
│ template1 │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ =c/postgres ↵│
│ │ │ │ │ │ postgres=CTc/postgres │
└───────────┴──────────┴──────────┴─────────────┴─────────────┴───────────────────────┘
(3 rows)
postgres=#
2014-03-07 19:24 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:
It should to have enough variability to define all styles proposed early. I hope, so this proposal is secure and simple for usage. Styles should be persistently saved in .psqlrc file - and some examples can be in documentation.* thick,* double,* single,* none,Possible styles (for each element)* column_separator,* row_separator,* header_separator,* border,So possible line elements are:So I propose little bit different proposal - choose one predefined style for any table lines elements. These styles are active only when "linestyle" is unicode.This experiment fails, but there are some interesting tips in discuss.HelloI am returning back to this topic. Last time I proposed styles:
http://www.postgresql.org/message-id/CAFj8pRCLgoKtrYjPbToncpgyfTRcZ-ZgfOwdc1jquLB+eDe0Tw@mail.gmail.com
http://postgres.cz/wiki/Pretty_borders_in_psqlUsage:\pset linestyle_border double\pset linestyle_header_separator single\pset linestyle_row_separator single\pset linestyle_column_separator single\pset linestyle unicode╔═══╤════════════╤═══════╗ ║ a │ b │ c ║ ╟───┼────────────┼───────╢ ║ 1 │ 2012-05-24 │ Hello ║ ╟───┼────────────┼───────╢ ║ 2 │ 2012-05-25 │ Hello ║ ║ │ │ World ║ ╚═══╧════════════╧═══════╝ (2 rows)Comments, ideas ?Regards
Pavel
Вложения
В списке pgsql-hackers по дате отправления: