Skip site navigation (1) Skip section navigation (2)

Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Eric Ridge <eebbrr(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date: 2011-10-30 04:53:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On 10/29/2011 03:26 PM, Eric Ridge wrote:
> Would y'all accept a patch that extended the "SELECT *" syntax to let
> you list fields to exclude from the A_Star?
> Quite regularly I'll be testing queries via psql and want to see all
> the columns from a fairly wide table except maybe a giant text or xml
> column.  A syntax like:
>       SELECT * EXCLUDING (big_col1, big_col2) FROM foo;

If it is quite regular I would actually argue two things:

1. Use a view
2. You haven't normalized correctly

I am not trying to be a pedantic zealot or anything but those would be 
my arguments against.


Joshua D. Drake
Command Prompt, Inc. -
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference -
@cmdpromptinc - @postgresconf - 509-416-6579

In response to


pgsql-hackers by date

Next:From: Darren DuncanDate: 2011-10-30 08:10:13
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Previous:From: Pavel StehuleDate: 2011-10-30 03:37:49
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group