selecting all columns but one - Mailing list pgsql-general

From blackwater dev
Subject selecting all columns but one
Date
Msg-id 34a9824e0907280612v737aef45s22e940b1f39c881f@mail.gmail.com
Whole thread Raw
Responses Re: selecting all columns but one
Re: selecting all columns but one
Re: selecting all columns but one
List pgsql-general
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?

Thanks!

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Upgrading from 8.3 to 8.4 and Integer datatimes?
Next
From: Robert James
Date:
Subject: Re: Relational Algebra and Aggregate Functions