There's probably some way to pull all the field names from the metadata tables and build a query on-the-fly that selects all but the offensive one.
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Doughty Sent: Wednesday, November 28, 2007 11:07 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Select all fields except one Hi, Is there a way of selecting all fields except for one in particular? I'd like to create a query that says something like: select * except fieldx What I'm hoping to achieve is a query that can be valid for a number of different tables, although the field I don't want to select is always called the same (field_not_wanted, for example). I've been told that an array could work in this case but I'm not reallly sure about how to go about this. 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
<<image001.jpg>>