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



--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to