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, whole thread or download thread mbox)
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);
> 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                    
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


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-2017 The PostgreSQL Global Development Group