Re: selecting all columns but one

In response to blackwater dev :
> I have a table with a lot of columns.  One of the columns I want to alias so
> have a query of:
>
> select *, column as newname from mytable.
>
> The problem is I now have column and newname in the results.  I don't want to
> select column by column.  How can I do a select * but omit one?

You can't.

The only way: ask information_schema.columns and build a string that
contains all except the special column and execute that string. (within
a function, plpgsql).


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net