title: View error in PostgreSQL
body: <p>I have a large query in a PostgreSQL database.
  The Query is something like this:</p>
  
  <pre><code>SELECT * FROM table1, table2, ... WHERE table1.id = table2.id...
  </code></pre>
  
  <p>When I run this query as a sql query, the it returns the wanted row.</p>
  
  <p>But when I tries to use the same query to create a view, it returns an error:</p>
  
  <p>"error: column "id" specified more than once."</p>
  
  <p>(I use pgAdminIII when executing the queries.)</p>
  
  <p>I'll guess this happens because the resultset will have more than one column named "id". Is there someway to solve this, without writing all the column names in the query?</p>