[postgis-users] Except

[Matt Doughty]

Hi,

 

Is there a way of selecting all fields except one in particular? I'd
like to create a query that says something like: select * except
field01.  The thing is the query needs to be valid for a number of
different tables, each with a different set of fields apart from one
(gid), which I don't want to select.

 

Cheers,

 

Matt

 

 

 

Matt Doughty

 

GEOGRAMA S.L.

Tel.:  +34 945 13 13 72    652 77 14 15

Fax: +34 945 23 03 40 

www.geograma.com

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071128/4f12d6e1/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3743 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071128/4f12d6e1/attachment.jpg>