PostgreSQL: SELECT all fields, filter some
- by Adam Matan
Hi,
In one of our databases, there is a table with dozens of columns, one of which is a geometry column.
I want to SELECT rows from the table, with the geometry transformed to another SRID. I want to use something like:
`SELECT *`
in order to avoid:
SELECT col_a, col_b, col_c, col_d, col_e, col_f,
col_g, col_h, transform(the_geom, NEW_SRID), ..., col_z
Any ideas?
Adam