title: PostgreSQL: SELECT all fields, filter some
body: <p>In one of our databases, there is a table with dozens of columns, one of which is a geometry column. </p>
  
  <p>I want to <code>SELECT</code> rows from the table, with the geometry transformed to another <a href="http://en.wikipedia.org/wiki/SRID" rel="nofollow noreferrer">SRID</a>. I want to use something like:</p>
  
  <pre><code>`SELECT *`
  </code></pre>
  
  <p>in order to avoid:</p>
  
  <pre><code>SELECT col_a, col_b, col_c, col_d, col_e, col_f, 
         col_g, col_h, transform(the_geom, NEW_SRID), ..., col_z
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Adam</p>