title: Alter character varying column's length in PostgreSQL
body: <p>I have table in production which has column type <code>character varying(255);</code></p>
  
  <p>All rows has entry in that column no longer than 15 characters and never will be larger as well. I decide to reduce its size to 15 characters with following command which I found on sof:</p>
  
  <p><code>ALTER TABLE user_template ALTER COLUMN "TYPE" character varying(15);</code></p>
  
  <p>I got following error:</p>
  
  <pre><code>ERROR:  syntax error at or near "character"
  LINE 1: ...LTER TABLE user_template ALTER COLUMN "type" character ...
                                                          ^
  </code></pre>
  
  <p>Can you help me to fix it? Thanks.</p>