Re: Select all fields except one

On Wed, Nov 28, 2007 at 05:06:45PM +0100, Matt Doughty wrote:
> 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).

This sounds like self-modifying code. I'd submit that you're trying
to do the wrong thing in the first place, and that you should look
over your design for flaws like this and re-do that design.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate