One way would be to put the_geom in a separate table and link it to the table with the attributes with a unique id column.

-Steve W

Stefan Schwarzer wrote:
Hi,

does anyone know how to build a query that SELECTs all fields but not the_geom? I have a couple of tables, holding statistical information as well as the geospatial one. When I query the table I'd like to query only the statistical part - not the geospatial, which is not necessary and slows done incredibly the query. I searched a bit within the Postgres SQL domain. It seems there is an EXCEPT statement, but it seems that it works differently...

Thanks for any help,

Stef

Reply via email to