From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Invalid byte sequence for encoding UTF-8 0xc3\n |
Date: | 2017-07-30 21:32:32 |
Message-ID: | CA+FnnTxi8LC20yz4ce=aX7KLOHV7eXn4vT3bG_fn0zONoTyLzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, John,
On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> 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.
Looks like mine are as well:
draft=# \l+
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges | Size | Tablespace | Description
-----------+----------+----------+---------+-------+-----------------------+---------+------------+--------------------------------------------
draft | postgres | UTF8 | C | C |
| 11 MB | pg_default |
leagues | postgres | UTF8 | C | C |
| 5865 kB | pg_default |
postgres | postgres | UTF8 | C | C |
| 5865 kB | pg_default | default administrative connection
database
template0 | postgres | UTF8 | C | C | =c/postgres
+| 5865 kB | pg_default | unmodifiable empty database
| | | | |
postgres=CTc/postgres | | |
template1 | postgres | UTF8 | C | C | =c/postgres
+| 5865 kB | pg_default | default template for new databases
| | | | |
postgres=CTc/postgres | | |
(5 rows)
I'm using the draft one.
Thank you.
>
>
> --
> john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Samad | 2017-07-30 23:15:29 | partitioning question |
Previous Message | Kurt Kartaltepe | 2017-07-30 20:57:50 | Fwd: Planner oversight for GIN indices? |