Avoid querying the_geom field in Postgis - how?

Stephen Woodbridge woodbri at SWOODBRIDGE.COM
Tue Feb 21 05:17:02 PST 2006


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
> 



More information about the MapServer-users mailing list