Re: select !working - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: select !working
Date
Msg-id 1011177868.9010.42.camel@linda
Whole thread Raw
In response to select !working  (denis@coralindia.com)
List pgsql-novice
On Wed, 2002-01-16 at 05:29, denis@coralindia.com wrote:
> Hi all,
>
> After spending a day, i have been able to start postmaster on Windows 2000
> Professional (using Cygwin)
>
> I am facing one problem. I have created database and users also. I can also
> able to create tables, insert rows in tables but when i issue SELECT, it
> gives error "less : not found". I am issuing a very basic select statement.
> Can anyone give any help.
>
> db=> CREATE TABLE test (aa numeric, bb text);
> CREATE
> db=> INSERT INTO TEST VALUES (100,'Denis');
> INSERT 54555 1
> db=> SELECT * FROM test;
> less : not found
> db=>

I have no experience of Cygwin, but less is a pager filter that is very
commonly used in Unix.  The pager is normally set by the environment
variable PAGER; so if you have "more" but not "less", set PAGER=more
before you start psql.  (Or unset PAGER; "more" is used by default if
PAGER is not set.)  You can use "\pset pager" in psql to toggle the use
of the pager on and off.
--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Jesus said unto her, I am the resurrection, and the
      life; he that believeth in me, though he were dead,
      yet shall he live"                John 11:25

Attachment

pgsql-novice by date:

Previous
From: denis@coralindia.com
Date:
Subject: select !working
Next
From: Einar Karttunen
Date:
Subject: Re: Counting distinct rows