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

Re: select !working

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: denis(at)coralindia(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: select !working
Date: 2002-01-16 10:44:26
Message-ID: 1011177868.9010.42.camel@linda (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 2002-01-16 at 05:29, denis(at)coralindia(dot)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(dot)Elphick(at)lfix(dot)co(dot)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 

In response to

Responses

pgsql-novice by date

Next:From: Einar KarttunenDate: 2002-01-16 11:03:07
Subject: Re: Counting distinct rows
Previous:From: John TaylorDate: 2002-01-16 10:38:12
Subject: Counting distinct rows

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