Selecting all but a few fields in a query

From: thefronny(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Selecting all but a few fields in a query
Date: 2007-11-05 16:45:13
Message-ID: 1194281113.870030.15380@v29g2000prd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

thx

r

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2007-11-05 16:50:47 How to temporarily disable a table's FK constraints?
Previous Message Pit M. 2007-11-05 16:02:03 Re: Problems with PostgreSQL DBI-Link / DBD-ODBC