[postgis-users] views on tables with geometry

[Tyler Mitchell]

Views are fine.  Geometry_columns, as you note, are needed by some 
applications and may even be required for an application to use the OGC 
spec (?anyone?).  I use views a lot, but if you plan on doing processing 
of data and large queries, you'll find creating intermediate tables will 
boost performance.

Tyler

postgis-users-bounces at postgis.refractions.net wrote on 04/15/2004 10:26:12 
AM:

> 
> Do normal Postgres views work OK with PostGIS tables? (no problems or 
issues I
> should know of?
> 
> I know one application only makes available tables listed in the
> geometry_columns table, so views don't work with that application, but I 
was
> wondering if that is also an issue for PostGIS.
> 
> (Hopefully all my newbie questions will be asked & answered shortly 
> & I can get
> down to some nice (quiet) use of PostGIS :-)
> 
> I figure multiple emails are tidier in the archives than asking 
everyting in
> one msg...
> 
> 
> Thanks,
> 
>   Brent Wood
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users