Search Postgresql Archives

Re: Invalid byte sequence for encoding UTF-8 0xc3\n

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux