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