Re: [GENERAL] character encoding of the postgres database

2017-05-10 Thread Sandeep Gupta
Thank you. On Wed, May 10, 2017 at 12:54 PM, Adrian Klaver wrote: > On 05/10/2017 08:48 AM, Sandeep Gupta wrote: >> >> Currently, the postgres database by has SQL_ASCII encoding. >> >> psql -p 5771 postgres -l >> List of databases >>Name

Re: [GENERAL] character encoding of the postgres database

2017-05-10 Thread Adrian Klaver
On 05/10/2017 08:48 AM, Sandeep Gupta wrote: Currently, the postgres database by has SQL_ASCII encoding. psql -p 5771 postgres -l List of databases Name| Owner | Encoding | Collate | Ctype | Access privileges

Re: [GENERAL] character encoding of the postgres database

2017-05-10 Thread Peter Eisentraut
On 5/10/17 11:48, Sandeep Gupta wrote: > Currently, the postgres database by has SQL_ASCII encoding. > Is it possible to start the postgres database with UTF-8 encoding, instead > of modifying it later. This is done when initdb is run, with the --locale and/or --encoding option. -- Peter

[GENERAL] character encoding of the postgres database

2017-05-10 Thread Sandeep Gupta
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