Re: [SQL] Exclude fields from SELECT command

2009-03-17 Thread Steve Midgley
At 05:20 PM 3/16/2009, pgsql-sql-ow...@postgresql.org wrote: In-Reply-To: <1992170861895942...@unknownmsgid> References: <1992170861895942...@unknownmsgid> Date: Mon, 16 Mar 2009 22:45:54 +0100 Message-ID: <162867790903161445i78127316s1c0deb3bec0e1...@mail.gmail.com> Subject: Re: Exclude fields

Re: [SQL] Exclude fields from SELECT command

2009-03-17 Thread sathiya psql
In what way it is devil Clarifications. .. > I know better solution. Use only thin tables. Wide tables are devil. :) >

Re: [SQL] Exclude fields from SELECT command

2009-03-16 Thread Pavel Stehule
Hello >> >> > > Workaround is create a view on that table excluding those 5 fields and then > select * from that view . > I know better solution. Use only thin tables. Wide tables are devil. :) regards Pavel Stehule > > With regards > Ashish Karalkar > > > > -- > Sent via pgsql-sql mailing lis

Re: [SQL] Exclude fields from SELECT command

2009-03-16 Thread Ashish Karalkar
Pavel Stehule wrote: 2009/3/16 Charles Tam : 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 n

Re: [SQL] Exclude fields from SELECT command

2009-03-16 Thread Pavel Stehule
2009/3/16 Charles Tam : > 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

[SQL] Exclude fields from SELECT command

2009-03-16 Thread Charles Tam
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