Re: Unicode UTF-8 table formatting for psql text output - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Unicode UTF-8 table formatting for psql text output
Date
Msg-id 407d949e0910261012t78262242p8394d1c167513e73@mail.gmail.com
Whole thread Raw
In response to Re: Unicode UTF-8 table formatting for psql text output  (Roger Leigh <rleigh@codelibre.net>)
Responses Re: Unicode UTF-8 table formatting for psql text output  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Unicode UTF-8 table formatting for psql text output  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
2009/10/25 Roger Leigh <rleigh@codelibre.net>:
> 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)
>


While i agree this looks nicer I wonder what it does to things like
excel/gnumeric/ooffice auto-recognizing table layouts and importing
files. I'm not sure our old format was so great for this so maybe this
is actually an improvement I'm asking for. But as long as we're
changing the format... It would at at least be good to test the
behaviour



--
greg

pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Scaling up deferred unique checks and the after trigger queue
Next
From: Cédric Villemain
Date:
Subject: Re: per table random-page-cost?