Re: [patch] Proposal for \rotate in psql

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 │ │ │ │ ✓ │ │ │ │ ✓
└───────────┴────────┴────────┴────┴──────┴──────┴────────┴──────┴────

In response to

Browse pgsql-hackers by date

  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