Pages

Wednesday, November 20, 2013

new border styles for psql

A few years ago I wrote a first patch that add a new styles of unicode table borders in psql.

Today I release new patch for 9.3 with new two styles. Download patch from http://postgres.cz/files/patches/more_linestyles-93-20131008.diff url.
\pset linestyle unicode-double5 style
┌───────────┬──────────┬──────────┬────────────┬────────────┬───────────────────────┐
│   Name    │  Owner   │ Encoding │  Collate   │   Ctype    │   Access privileges   │
┝━━━━━━━━━━━┿━━━━━━━━━━┿━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━━━━━━━━━━━━┥
│ postgres  │ postgres │ UTF8     │ en_US.utf8 │ en_US.utf8 │                       │
│ template0 │ postgres │ UTF8     │ en_US.utf8 │ en_US.utf8 │ =c/postgres           │
│           │          │          │            │            │ postgres=CTc/postgres │
│ template1 │ postgres │ UTF8     │ en_US.utf8 │ en_US.utf8 │ =c/postgres           │
│           │          │          │            │            │ postgres=CTc/postgres │
└───────────┴──────────┴──────────┴────────────┴────────────┴───────────────────────┘

\pset linestyle unicode-double6 style
┌───────────┬──────────┬──────────┬────────────┬────────────┬───────────────────────┐
│   Name    │  Owner   │ Encoding │  Collate   │   Ctype    │   Access privileges   │
╞═══════════╪══════════╪══════════╪════════════╪════════════╪═══════════════════════╡
│ postgres  │ postgres │ UTF8     │ en_US.utf8 │ en_US.utf8 │                       │
│ template0 │ postgres │ UTF8     │ en_US.utf8 │ en_US.utf8 │ =c/postgres           │
│           │          │          │            │            │ postgres=CTc/postgres │
│ template1 │ postgres │ UTF8     │ en_US.utf8 │ en_US.utf8 │ =c/postgres           │
│           │          │          │            │            │ postgres=CTc/postgres │
└───────────┴──────────┴──────────┴────────────┴────────────┴───────────────────────┘

2 comments:

  1. I like it! Will you be submitting this for 9.4?

    ReplyDelete
  2. No, it is over basic functionality - few years I tried it and patch was rejected. So I use use this form - this patch is free and available for users, packagers, ..

    ReplyDelete