Re: Exclude fields from SELECT command

From: Ashish Karalkar <ashishka(at)synechron(dot)com>
To:
Cc: Charles Tam <c(dot)tam(at)osm(dot)net(dot)au>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Exclude fields from SELECT command
Date: 2009-03-17 05:17:17
Message-ID: 49BF325D.4050908@synechron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Pavel Stehule wrote:
> 2009/3/16 Charles Tam <c(dot)tam(at)osm(dot)net(dot)au>:
>
>> 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?
>>
>>
>>
>>
>
> hello
>
> no, there are no way
>
> regards
> Pavel Stehule
>
>
>> Thanks for your time.
>>
>>
>>
>> Kind Regards
>>
>> Charles
>>
>>
>>
>
>
Workaround is create a view on that table excluding those 5 fields and
then select * from that view .

With regards
Ashish Karalkar

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2009-03-17 05:27:57 Re: Exclude fields from SELECT command
Previous Message Pavel Stehule 2009-03-16 21:45:54 Re: Exclude fields from SELECT command