Re: [patch] Proposal for \rotate in psql - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: [patch] Proposal for \rotate in psql
Date
Msg-id 8824f523-dc52-484f-a898-8346d8f5e990@mm
Whole thread Raw
In response to [patch] Proposal for \rotate in psql  ("Daniel Verite" <daniel@manitou-mail.org>)
List 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  │         │          │    │ ✓      │     │      │     │ ✓
└───────────┴────────┴────────┴────┴──────┴──────┴────────┴──────┴────



pgsql-hackers by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: On-demand running query plans using auto_explain and signals
Next
From: Petr Jelinek
Date:
Subject: Re: WIP: Rework access method interface