Re: Select all fields except one - Mailing list pgsql-general

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.

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