Re: Exclude fields from SELECT command - Mailing list pgsql-sql

Pavel Stehule wrote:
> 2009/3/16 Charles Tam <c.tam@osm.net.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