title: Postgres alter view add column
body: <p>I want to alter a view and add a new column in it. I have:</p>
  
  <pre><code>ALTER VIEW folders_contents
  AS
  SELECT files.id,
      files.name,
      files.filesize,
      files.updated,
      files.deleted,
     FROM files
  UNION ALL
   SELECT folders.id,
      folders.name,
      0 AS filesize,
      folders.updated,
      folders.deleted,
      FROM folders
    ORDER BY 8, 2
  GO
  </code></pre>
  
  <p>The problem is that it shows:</p>
  
  <blockquote>
    <p>[Err] ERROR:  syntax error at or near "AS"</p>
  </blockquote>
  
  <p>Is the first time I have to do with views, I need some help :)</p>