Hi,

does anybody know how I can have psql scroll wide tables instead of wrapping them?

At the moment it uses the pager if there are too many rows. But although I can scroll horizontal
then, it still wraps some rows around.

Additionally It would be nice, if the pager is used as soon as the width is to wide (independant
from the amount of rows).

TIA
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nabil Sayegh <postgresql (AT) e-trolley (DOT) de> writes:

The problem is with your pager. Using less (set the PAGER environment
variable to less) and setting the LESS environment variable to -S (see
the less man page for details) will do the work.

It would, indeed.

Regards,
Manuel.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Manuel Sugawara wrote:
Thanks
-S was exactly what I wanted.

bye
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Use a pager that is capable of "wide" output. On many systems,
this is accomplished by the program "less"

Use "\pset pager always" inside of psql to force it to always
invoke the pager.

- --
Greg Sabino Mullane greg (AT) turnstep (DOT) com
PGP Key: 0x14964AC8 200402112300

-----BEGIN PGP SIGNATURE-----

iD8DBQFAKvqUvJuQZxSWSsgRAl81AJ9qYx76Qnd0rFFKgB4SrU 0MItR7QQCfVvbr
T5newkyKR02seKuqcqOVCTE=
=mZoS
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly