From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Invalid byte sequence for encoding UTF-8 0xc3\n |
Date: | 2017-07-30 20:53:54 |
Message-ID: | aa65d7c4-da2d-5304-5a72-9e319a10c7be@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/30/2017 1:43 PM, Igor Korot wrote:
>> what encodings are default on your system ? `\l+` in psql should show the
>> encodings.
> Is this "backslash + pipe + plus-sign"?
>
> Trying it gives: "Invalid command".
\ + lower case L + plus sign, thats the psql metacommand to list all
databases with extra info....
postgres=# \l+
List of databases
Name | Owner | Encoding | Collate | Ctype |
Access privileges | Size | Tablespace | Description
----------------+-----------+----------+-------------+-------------+-----------------------+---------+------------+--------------------------------------------
junk | pierce | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 6586 kB | pg_default |
observers_test | observers | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 207 MB | pg_default |
pierce | pierce | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 6786 kB | pg_default |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 6610 kB | pg_default | default administrative
connection database
scac | scac | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 75 MB | pg_default |
scac_save | scac | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 105 MB | pg_default |
smf | smf | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 34 MB | pg_default |
sympa | sympa | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 6898 kB | pg_default |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres +| 6457 kB | pg_default | unmodifiable empty database
| | | | |
postgres=CTc/postgres | | |
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres +| 6465 kB | pg_default | default template for new
databases
| | | | |
postgres=CTc/postgres | | |
tendenci | tendenci | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 15 MB | pg_default |
test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8
| | 6634 kB | pg_default |
(12 rows)
for instance, all my databases are UTF8 on that server.
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | Kurt Kartaltepe | 2017-07-30 20:57:50 | Fwd: Planner oversight for GIN indices? |
Previous Message | Igor Korot | 2017-07-30 20:43:42 | Re: Invalid byte sequence for encoding UTF-8 0xc3\n |