title: Can't change datatype of column in postgres
body: <p>I'm trying to change the datatype of a column to varchar but get the following error</p>
  
  <pre><code>ERROR:  syntax error at or near "type" at character 40
  </code></pre>
  
  <p>My code looks as follows</p>
  
  <pre><code>alter table n_logs alter column action type varchar(100);
  </code></pre>
  
  <p>I'm running PostgreSQL 7.4.13 (Yeah, I know I need to upgrade)</p>