Re: Unicode UTF-8 table formatting for psql text output

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Roger Leigh <rleigh(at)codelibre(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unicode UTF-8 table formatting for psql text output
Date: 2009-10-26 15:53:01
Message-ID: 1256572381.25345.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On sön, 2009-10-25 at 23:48 +0000, Roger Leigh wrote:
> Just for reference, this is what the output looks like (abridged)
> using the attached patch. Should display fine if your mail client handles
> UTF-8 messages correctly:
>
> rleigh=# \l
> List of databases
> Name │ Owner │ Encoding │ Collation │ Ctype │ Access privileges
> ─────────────────┼──────────┼──────────┼─────────────┼─────────────┼───────────────────────
> merkelpb │ rleigh │ UTF8 │ en_GB.UTF-8 │ en_GB.UTF-8 │
> postgres │ postgres │ UTF8 │ en_GB.UTF-8 │ en_GB.UTF-8 │
> projectb │ rleigh │ UTF8 │ en_GB.UTF-8 │ en_GB.UTF-8 │
> rleigh │ rleigh │ UTF8 │ en_GB.UTF-8 │ en_GB.UTF-8 │
> […]
> template0 │ postgres │ UTF8 │ en_GB.UTF-8 │ en_GB.UTF-8 │ =c/postgres ↵
> │ │ │ │ │ postgres=CTc/postgres
> template1 │ postgres │ UTF8 │ en_GB.UTF-8 │ en_GB.UTF-8 │ =c/postgres ↵
> │ │ │ │ │ postgres=CTc/postgres
> […]
> (17 rows)

That's pretty much what I had in mind. Cool.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-10-26 15:54:15 Re: Endgame for all those SELECT FOR UPDATE changes: fix plan node order
Previous Message Greg Smith 2009-10-26 15:52:16 Re: Parsing config files in a directory