title: Change Database Collation, Ctype in Postgresql
body: <p>how do I change Collation, cType to - <code>en_IN</code> from <code>en_US.UTF-8</code></p>
  
  <pre><code>                              List of databases
     Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges   
  -----------+----------+----------+-------------+-------------+-----------------------
   postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
   template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                               : postgres=CTc/postgres
   template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                               : postgres=CTc/postgres
  </code></pre>
  
  <p>my current postgresversion is 8.4
  ive installed it using</p>
  
  <pre><code>sudo apt-get install postgresql-8.4 postgresql-contrib-8.4
  </code></pre>
  
  <p>im doing this in my ubuntu amazon server ec2</p>