Re: Exclude fields from SELECT command

Поиск
Список
Период
Сортировка
От Ashish Karalkar
Тема Re: Exclude fields from SELECT command
Дата
Msg-id 49BF325D.4050908@synechron.com
обсуждение исходный текст
Ответ на Re: Exclude fields from SELECT command  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Exclude fields from SELECT command  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Exclude fields from SELECT command
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Exclude fields from SELECT command