Exclude fields from SELECT command

From: "Charles Tam" <c(dot)tam(at)osm(dot)net(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Exclude fields from SELECT command
Date: 2009-03-16 20:56:21
Message-ID: 000601c9a679$a9966830$fcc33890$@tam@osm.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Everybody

I've a table with 35 fields and would like to perform a SELECT command
without specifying every single field.

As such, I've use the SELECT * command. Is there an approach to exclude 5
fields from being returned?

Thanks for your time.

Kind Regards

Charles

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2009-03-16 21:45:54 Re: Exclude fields from SELECT command
Previous Message Paul Dam 2009-03-16 14:44:14 RE: [SQL] RE : [SQL] Convert text from UTF8 to ASCII