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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

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