http://postgres.cz/index.php?action=history&feed=atom&title=Pretty_borders_in_psql 2026-05-14T00:50:56Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=Pretty_borders_in_psql&diff=530&oldid=prev 2013-11-22T08:28:09Z

<p></p> <p><b>Nová stránka</b></p><div>Pretty borders is simple and secure patch to PostgreSQL that enhances &quot;line graphic&quot; possibilities in PostgreSQL&#039;s console:<br /> <br /> ==Installation==<br /> You need source code of PostgreSQL:<br /> <br /> # download patch<br /> # apply patch and compile<br /> # install<br /> <br /> &lt;pre&gt;<br /> pavel ~/src/postgresql $ patch -p1 &lt; more_linestyles.diff <br /> patching file src/bin/psql/command.c<br /> patching file src/bin/psql/print.c<br /> patching file src/bin/psql/print.h<br /> patching file src/bin/psql/tab-complete.c<br /> &lt;/pre&gt;<br /> <br /> ==Usage==<br /> You can set a combination of border type (0..4) and linestyle:<br /> &lt;pre&gt;<br /> postgres=# \pset border 2<br /> Border style is 2.<br /> postgres=# \pset linestyle <br /> ascii unicode unicode-double1 unicode-double3 <br /> old-ascii unicode2 unicode-double2 unicode-double4 <br /> postgres=# \pset linestyle unicode-double2<br /> Line style is unicode-double2.<br /> postgres=# select * from mytab;<br /> ╔═══╤════════════╤═══════╗<br /> ║ a │ b │ c ║<br /> ╠═══╪════════════╪═══════╣<br /> ║ 1 │ 2012-05-24 │ Hello ║<br /> ║ 2 │ 2012-05-25 │ Hello ║<br /> ║ │ │ World ║<br /> ╚═══╧════════════╧═══════╝<br /> (2 rows)<br /> <br /> postgres=# \pset border 3<br /> Border style is 3.<br /> postgres=# select * from mytab;<br /> a │ b │ c <br /> ═══╪════════════╪═══════<br /> 1 │ 2012-05-24 │ Hello<br /> ───┼────────────┼───────<br /> 2 │ 2012-05-25 │ Hello <br /> │ │ World<br /> (2 rows)<br /> &lt;/pre&gt;<br /> <br /> ==Possible modes==<br /> &lt;pre&gt;<br /> postgres=# \pset linestyle ascii <br /> Line style is ascii.<br /> postgres=# select * from mytab ;<br /> +---+------------+-------+<br /> | a | b | c |<br /> +---+------------+-------+<br /> | 1 | 2012-05-24 | Hello |<br /> +---+------------+-------+<br /> | 2 | 2012-05-25 | Hello+|<br /> | | | World |<br /> +---+------------+-------+<br /> (2 rows)<br /> <br /> postgres=# select * from mytab ;<br /> +---+------------+-------+<br /> | a | b | c |<br /> +---+------------+-------+<br /> | 1 | 2012-05-24 | Hello |<br /> +---+------------+-------+<br /> | 2 | 2012-05-25 | Hello |<br /> | : World |<br /> +---+------------+-------+<br /> (2 rows)<br /> <br /> postgres=# \pset linestyle unicode<br /> Line style is unicode.<br /> postgres=# select * from mytab ;<br /> ┌───┬────────────┬───────┐<br /> │ a │ b │ c │<br /> ├───┼────────────┼───────┤<br /> │ 1 │ 2012-05-24 │ Hello │<br /> ├───┼────────────┼───────┤<br /> │ 2 │ 2012-05-25 │ Hello↵│<br /> │ │ │ World │<br /> └───┴────────────┴───────┘<br /> (2 rows)<br /> <br /> postgres=# \pset linestyle unicode2<br /> Line style is unicode2.<br /> postgres=# select * from mytab ;<br /> ┌───┬────────────┬───────┐<br /> │ a │ b │ c │<br /> ├───┴────────────┴───────┤<br /> │ 1 │ 2012-05-24 │ Hello │<br /> ├───┼────────────┼───────┤<br /> │ 2 │ 2012-05-25 │ Hello │<br /> │ │ │ World │<br /> └────────────────────────┘<br /> (2 rows)<br /> <br /> postgres=# \pset linestyle unicode-double1<br /> Line style is unicode-double1.<br /> postgres=# select * from mytab ;<br /> ╔═══╤════════════╤═══════╗<br /> ║ a │ b │ c ║<br /> ╟───┼────────────┼───────╢<br /> ║ 1 │ 2012-05-24 │ Hello ║<br /> ╟───┼────────────┼───────╢<br /> ║ 2 │ 2012-05-25 │ Hello ║<br /> ║ │ │ World ║<br /> ╚═══╧════════════╧═══════╝<br /> (2 rows)<br /> <br /> postgres=# \pset linestyle unicode-double2<br /> Line style is unicode-double2.<br /> postgres=# select * from mytab ;<br /> ╔═══╤════════════╤═══════╗<br /> ║ a │ b │ c ║<br /> ╠═══╪════════════╪═══════╣<br /> ║ 1 │ 2012-05-24 │ Hello ║<br /> ╟───┼────────────┼───────╢<br /> ║ 2 │ 2012-05-25 │ Hello ║<br /> ║ │ │ World ║<br /> ╚═══╧════════════╧═══════╝<br /> (2 rows)<br /> <br /> postgres=# \pset linestyle unicode-double3<br /> Line style is unicode-double3.<br /> postgres=# select * from mytab ;<br /> ╔═══╦════════════╦═══════╗<br /> ║ a ║ b ║ c ║<br /> ╠═══╩════════════╩═══════╣<br /> ║ 1 │ 2012-05-24 │ Hello ║<br /> ╟───┼────────────┼───────╢<br /> ║ 2 │ 2012-05-25 │ Hello ║<br /> ║ │ │ World ║<br /> ╚════════════════════════╝<br /> (2 rows)<br /> <br /> postgres=# \pset linestyle unicode-double4<br /> Line style is unicode-double4.<br /> postgres=# select * from mytab ;<br /> ╔═══╦════════════╦═══════╗<br /> ║ a ║ b ║ c ║<br /> ╠═══╬════════════╬═══════╣<br /> ║ 1 ║ 2012-05-24 ║ Hello ║<br /> ╟───╫────────────╫───────╢<br /> ║ 2 ║ 2012-05-25 ║ Hello ║<br /> ║ ║ ║ World ║<br /> ╚═══╩════════════╩═══════╝<br /> (2 rows)<br /> <br /> unicode-double5 style (note: inside proposal for pg9.4. this style is renamed to unicode-bold1)<br /> ┌───────────┬──────────┬──────────┬────────────┬────────────┬───────────────────────┐<br /> │ Name │ Owner │ Encoding │ Collate │ Ctype │ Access privileges │<br /> ┝━━━━━━━━━━━┿━━━━━━━━━━┿━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━━━━━━━━━━━━┥<br /> │ postgres │ postgres │ UTF8 │ en_US.utf8 │ en_US.utf8 │ │<br /> │ template0 │ postgres │ UTF8 │ en_US.utf8 │ en_US.utf8 │ =c/postgres │<br /> │ │ │ │ │ │ postgres=CTc/postgres │<br /> │ template1 │ postgres │ UTF8 │ en_US.utf8 │ en_US.utf8 │ =c/postgres │<br /> │ │ │ │ │ │ postgres=CTc/postgres │<br /> └───────────┴──────────┴──────────┴────────────┴────────────┴───────────────────────┘<br /> <br /> unicode-double6 style (note: inside proposal for pg9.4. this style is renamed to unicode-double5)<br /> ┌───────────┬──────────┬──────────┬────────────┬────────────┬───────────────────────┐<br /> │ Name │ Owner │ Encoding │ Collate │ Ctype │ Access privileges │<br /> ╞═══════════╪══════════╪══════════╪════════════╪════════════╪═══════════════════════╡<br /> │ postgres │ postgres │ UTF8 │ en_US.utf8 │ en_US.utf8 │ │<br /> │ template0 │ postgres │ UTF8 │ en_US.utf8 │ en_US.utf8 │ =c/postgres │<br /> │ │ │ │ │ │ postgres=CTc/postgres │<br /> │ template1 │ postgres │ UTF8 │ en_US.utf8 │ en_US.utf8 │ =c/postgres │<br /> │ │ │ │ │ │ postgres=CTc/postgres │<br /> └───────────┴──────────┴──────────┴────────────┴────────────┴───────────────────────┘<br /> <br /> postgres=# \pset border 0<br /> Border style is 0.<br /> postgres=# select * from mytab ;<br /> a b c <br /> ─ ────────── ─────<br /> 1 2012-05-24 Hello<br /> 2 2012-05-25 Hello↵<br /> World<br /> (2 rows)<br /> <br /> postgres=# \pset border 1<br /> Border style is 1.<br /> postgres=# select * from mytab ;<br /> a │ b │ c <br /> ───┼────────────┼───────<br /> 1 │ 2012-05-24 │ Hello<br /> 2 │ 2012-05-25 │ Hello↵<br /> │ │ World<br /> (2 rows)<br /> <br /> postgres=# \pset border 2<br /> Border style is 2.<br /> postgres=# select * from mytab ;<br /> ┌───┬────────────┬───────┐<br /> │ a │ b │ c │<br /> ├───┼────────────┼───────┤<br /> │ 1 │ 2012-05-24 │ Hello │<br /> │ 2 │ 2012-05-25 │ Hello↵│<br /> │ │ │ World │<br /> └───┴────────────┴───────┘<br /> (2 rows)<br /> <br /> postgres=# \pset border 3<br /> Border style is 3.<br /> postgres=# select * from mytab;<br /> a │ b │ c <br /> ───┼────────────┼───────<br /> 1 │ 2012-05-24 │ Hello<br /> ───┼────────────┼───────<br /> 2 │ 2012-05-25 │ Hello↵<br /> │ │ World<br /> (2 rows)<br /> <br /> postgres=# \pset border 4<br /> Border style is 4.<br /> postgres=# select * from mytab;<br /> ┌───┬────────────┬───────┐<br /> │ a │ b │ c │<br /> ├───┼────────────┼───────┤<br /> │ 1 │ 2012-05-24 │ Hello │<br /> ├───┼────────────┼───────┤<br /> │ 2 │ 2012-05-25 │ Hello↵│<br /> │ │ │ World │<br /> └───┴────────────┴───────┘<br /> (2 rows)<br /> &lt;/pre&gt;<br /> ==Downloads==<br /> * for PostgreSQL 9.1 http://postgres.cz/files/patches/more_linestyles-91-20120524.diff<br /> * for PostgreSQL 9.2 http://postgres.cz/files/patches/more_linestyles-92-20120524.diff<br /> * for PostgreSQL 9.3 http://postgres.cz/files/patches/more_linestyles-93-20131008.diff</div>

imported>Pavel