Skip site navigation (1) Skip section navigation (2)

Re: Simple question

From: "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>
To: Fredrick Bartlett <palmtreefrb(at)earthlink(dot)net>, PostgreSQL novice mailing list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Simple question
Date: 2000-08-26 18:29:25
Message-ID: 00082614350305.26454@comptechnews (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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

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:

export PAGER

If you want to install the "less" program, you can find it at:

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(at)comptechnews(dot)com ---------
- CompTechNews Message Board -
- CompTechServ Tech Services -
---------- ------------

In response to

pgsql-novice by date

Next:From: David CantrellDate: 2000-08-26 18:41:31
Subject: Re: Simple question
Previous:From: Jesus AneirosDate: 2000-08-26 17:49:11
Subject: Re: Simple question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group