title: Postgres change Encoding SQL_ASCII to UTF8
body: <p>i want to change database encoding sql ascii to utf8 without drop database it is possible? (psql 9.5)
  (I'm afraid of data disruption)</p>
  
  <p>I'm trying this but doesn't work </p>
  
  <pre><code> update pg_database set encoding = pg_char_to_encoding('utf8') where datname = 'name'
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/haEad.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/haEad.png" alt="postgre"></a></p>