On 11/5/07, thefronny@xxxxxxxxx <thefronny@xxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
