Hi, John,
On Sun, Jul 30, 2017 at 4:53 PM, John R Pierce <pierce@xxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
