psql is saying that it cannot find the "less" paging program that it wants to
use to display multiple pages of output. The less program is like the "more"
program but has additional capabilities like being able to page forward and
backward.
You can try to find the "less" or "more" command:
which less
which more
If you have one of them, you can set the $PAGER environment variable to it in
your /etc/profile:
PAGER=more
export PAGER
If you want to install the "less" program, you can find it at:
http://home.flash.net/~marknu/less/
Most systems have less installed and I think its the default that psql tries to
use even when $PAGER is not set.
On Sat, 26 Aug 2000, Fredrick Bartlett wrote:
> Using psql, why do I get the following error???
>
> socaldata=# insert into test_tbl (FIELD1, FIELD2, FIELD3)
> socaldata-# values('a','bb','ccc');
> INSERT 18860 1
> socaldata=# select * from test_tbl;
> sh: less: command not found <<< why this error???
> socaldata=#
>
> Fredrick
--
-------- Robert B. Easter reaster@comptechnews.com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------