Re: Selecting all but a few fields in a query - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Selecting all but a few fields in a query
Date
Msg-id dcc563d10711060653h76b97d7ah9cbf27a48d8b16ef@mail.gmail.com
Whole thread Raw
In response to Selecting all but a few fields in a query  (thefronny@gmail.com)
List pgsql-general
On 11/5/07, thefronny@gmail.com <thefronny@gmail.com> wrote:
> I have a table with a lot of fields, some of which are type TEXT. I
> seem to have a lot of occasions where I'd like to see almost all of
> the fields in a query but a SELECT * will pull in the text fields,
> which then wrap across the screen, even using \x. Is there a variation
> of SELECT that is something like 'select all fields except these here
> WHERE...'? This would save me a lot of typing. I checked the docs but
> missed it if it's in there.

Nope, no such animal exists.

You could write something like it in pl/tcl or pl/C or such.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Next
From: "Scott Marlowe"
Date:
Subject: Re: young guy wanting (Postgres DBA) ammo