[postgis-users] Multiple Geometries in Single View

[Wesley Roberts]

Dear PostGIS users,

I am a new postgis user and have a question regarding views and multiple
geometry types. I understand that I can create a *view* where I select a
portion of my data using an sql statement and view that *view *in QGIS. I
would like to know if it is possible to create a *view *that contains
multiple geometry types, so for example: a view displaying points lines and
polygons from different tables within the my db?

The context to this question is as follows. Our organization needs to share
a number of GIS layers with an auditor as part of our validation process.
Instead of sending the auditor a "bucket load" of shapefiles with
instructions on what to look at, I would prefer to share one postGIS DB
with all the layers in tables and all of our geo-spatial requirements in
views. Is this possible?

Many thanks and looking forward to your responses.
Wesley

-- 
Dr Wesley Roberts
jwesroberts at gmail.com
Cell: +27(0)83 5355 646
skype: roberts-w

I hear...I forget
I see...and I remember
I do...and I understand
Ancient Chinese Proverb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131028/2ba706fd/attachment.html>