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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Einar Karttunen | 2002-01-16 11:03:07 | Re: Counting distinct rows |
Previous Message | John Taylor | 2002-01-16 10:38:12 | Counting distinct rows |