Re: psql output Horizontal scrollable ?

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


> I am new to this database, so forgive me if this is too novice.
> I would like to know if there is any way to set the psql command
> output horizontal scrollable ?

One solution is to check out the "expanded" output mode, which can
be very handy in psql. Just toggle it on and off with \x

As far as the scrolling, that is set to whatever your pager is
set to. On unix-like systems, this is set with the environment
variable PAGER. The popular pager called "less" has horizontal
scrolling capability: just hit the right arrow and you will switch
to that mode. Another thing you may want to do is make sure the
pager is always used by psql by setting "\pset pager always"

So in summary, try this:

export PAGER=less
(call psql)
\pset pager always
(run your commands, hit the right arrow)

If you find yourself using the same commands all the time, such
as \pset pager always, you can add them to your .psqlrc file
(in your home directory) and they will be called automatically each
time you start psql.

All of the above assumes a bash shell on a unixy system, so if it
does not work for you, let us know what OS you are running on for
a better answer.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200511111250
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFDdNpXvJuQZxSWSsgRAlMSAKDwNLhTQJ42GZbKJbKIF5NHCt28UQCffPuP
75utEbOUrN02PYhMjK/Unzg=
=huVd
-----END PGP SIGNATURE-----