From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "thefronny(at)gmail(dot)com" <thefronny(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Selecting all but a few fields in a query |
Date: | 2007-11-06 14:53:12 |
Message-ID: | dcc563d10711060653h76b97d7ah9cbf27a48d8b16ef@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/5/07, thefronny(at)gmail(dot)com <thefronny(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-11-06 15:00:02 | Re: young guy wanting (Postgres DBA) ammo |
Previous Message | Tom Lane | 2007-11-06 14:48:37 | Re: any way for ORDER BY x to imply NULLS FIRST in 8.3? |