| From: | Sandeep Gupta <gupta(dot)sandeep(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | character encoding of the postgres database |
| Date: | 2017-05-10 15:48:59 |
| Message-ID: | CAAywg7u-Pi3D1TUsSsyHEQcZ6bAT9KALxVKE5qECRQsnLy3X6A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Currently, the postgres database by has SQL_ASCII encoding.
psql -p 5771 postgres -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+-----------+---------+-------+---------------------
postgres | sandeep | SQL_ASCII | C | C |
template0 | sandeep | SQL_ASCII | C | C | =c/sandeep +
| | | | | sandeep=CTc/sandeep
template1 | sandeep | SQL_ASCII | C | C | =c/sandeep +
| | | | | sandeep=CTc/sandeep
(3 rows)
Is it possible to start the postgres database with UTF-8 encoding, instead
of modifying it later.
Thanks
sandeep
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Dunavant | 2017-05-10 15:53:43 | Re: Select from tableA - if not exists then tableB |
| Previous Message | Mathieu Fenniak | 2017-05-10 15:45:07 | Re: Logical decoding CPU-bound w/ large number of tables |