Re: [GENERAL] character encoding of the postgres database

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 Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services