Postgres Pro
Downloads
Home   >   mailing lists

Thread: Simple question

Simple question

From
Fredrick Bartlett
Date:
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

Re: Simple question

From
Jesus Aneiros
Date:
Check the environment var PAGER. I think it's point to a wrong dir.

--
Jesus Aneiros Sosa
mailto:aneiros@jagua.cfg.sld.cu
http://jagua.cfg.sld.cu/~aneiros

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
>

Re: Simple question

From
David Cantrell
Date:
On Sat, Aug 26, 2000 at 09:04:04AM -0700, 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???

Looks like psql is trying to use 'less' for paging the results from your
select and can't find it.  Solutions are:
  download and install 'less' on your machine
  create a 'less' symlink to 'more'
The second one will help you immediately, the first is better.

--
David Cantrell | david@cantrell.org.uk | http://www.cantrell.org.uk/david

      I'm working on the assumption that chicks dig mad scientists

Re: Simple question

From
"Robert B. Easter"
Date:
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/ ------------