[postgis-users] Except

[Mad Thon]

Hi Matt,



Perhaps you can create the view based on only the columns 
you want. And then you can select * from view

Toni


----- Original Message ----

From: Matt Doughty <matt.doughty at geograma.com>

To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>

Sent: Wednesday, 28 November 2007 1:31:26

Subject: [postgis-users] Except



     

   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

               

           

   

  









      __________________________________________________________________ 
Yahoo! Singapore Answers 
Real people. Real questions. Real answers. Share what you know at http://answers.yahoo.com.sg