From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [patch] Proposal for \rotate in psql |
Date: | 2015-08-31 09:47:52 |
Message-ID: | 8824f523-dc52-484f-a898-8346d8f5e990@mm |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I wrote:
> What I like in that representation is that it looks good enough
> to be pasted directly into a document in a word processor.
And ironically, the nice unicode borders came out all garbled
in the mail, thanks to a glitch in my setup that mis-reformatted them
before sending.
Sorry about that, the results with unicode linestyle were supposed to be
as follows:
Example 2:
Rotated query results
┌────────────┬───────┬────────┬───────────┬──────────┐
│ username │ admin │ common │ mailusers │ readonly │
├────────────┼───────┼────────┼───────────┼──────────┤
│ daniel │ │ │ ✓ │ │
│ drupal │ │ │ │ │
│ dv │ ✓ │ ✓ │ │ │
│ extc │ │ │ │ ✓ │
│ extu │ │ │ │ │
│ foobar │ │ │ │ │
│ joel │ │ │ │ │
│ mailreader │ │ │ │ ✓ │
│ manitou │ ✓ │ │ ✓ │ │
│ postgres │ │ │ │ │
│ u1 │ │ ✓ │ │ │
│ u2 │ │ │ ✓ │ │
│ zaz │ │ │ ✓ │ │
└────────────┴───────┴────────┴───────────┴──────────┘
Example 3, rotated in the other direction
(Cut horizontally to fit in a mail, the actual output is 116 chars wide).
Rotated query results
┌───────────┬────────┬────────┬────┬──────┬──────┬────────┬──────┬────
│ username │ daniel │ drupal │ dv │ extc │ extu │ foobar │ joel │ mai...
├───────────┼────────┼────────┼────┼──────┼──────┼────────┼──────┼────
│ mailusers │ ✓ │ │ │ │ │ │ │
│ admin │ │ │ ✓ │ │ │ │ │
│ common │ │ │ ✓ │ │ │ │ │
│ readonly │ │ │ │ ✓ │ │ │ │ ✓
└───────────┴────────┴────────┴────┴──────┴──────┴────────┴──────┴────
From | Date | Subject | |
---|---|---|---|
Next Message | Petr Jelinek | 2015-08-31 10:28:19 | Re: WIP: Rework access method interface |
Previous Message | Shulgin, Oleksandr | 2015-08-31 09:30:13 | Re: On-demand running query plans using auto_explain and signals |