title: PostgreSQL 9.3: ALTER VIEW AS
body: <p>I am using PostgreSQL 9.3 version.</p>
  
  <p>I need to alter the view because of the table have been changed(added more columns) . </p>
  
  <p>Well! I have tried the following script which does not work for me:</p>
  
  <pre><code>ALTER VIEW View1 AS SELECT * FROM Table1;
  </code></pre>
  
  <p>Got an error:</p>
  
  <pre><code>Syntax error near 'AS'
  </code></pre>