Re: sqsh and right trimming of columns

On Mon, 14 Aug 2006 16:09:44 +0100, Richard Gration wrote:

On Mon, 14 Aug 2006 11:37:50 +0100, Richard Gration wrote:
but the main thing I want is right trimming of cols. Anything else is
gravy.

alignment of columns is obviously a requirement too, from what I said
earlier in my post

Maybe I'm missing something, but wouldn't that mean that you have to
pull down the whole result set before you can determine the width of
the columns?
While that could be feasible for a few rows, it's definitely not
something that I can envision for normal use - however, if you want to
submit a patch that adds this functionality you're welcome, and I will
definitely look at it.

I suppose that an alternative would be to add some formating commands
similar to what SQLPlus has so that you could limit the width of a
particular column to something that seems better than the actual width.

Michael (current sqsh maintainer)
--
Michael Peppler [TeamSybase] mpeppler@xxxxxxxxxxx - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html


.