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
