Subject: Re: [GENERAL] Poor performance with "large" table.
From: "Jack Gao" <weigao@hotmail.com>
===
Thanks for the reply, it's really helped.
Actually, after I installed less, I got another error message. "WARN:
terminal is not fully function.....". And I found that because of Rational
Rose, Rational Rose set envirement variable "TERM" to nutc, but cygwin need
it to be "cygwin".
Thanks again.
Jack
"Holger Marzen" <holger@marzen.de> wrote in message
news:mailman.1019032861.29298.pgsql-gen@basebeans.com...
> On Wed, 17 Apr 2002, pgsql-gen Newsgroup wrote:
>
> > 1. I'm keeping get error message when I use psql to get "large" data.
For
> > example, if one of my table has more than 74 records in it, when I run
> > "select * from tbl...." on psql, it give me "less: not found" message.
Also,
> > if I run "\df" on psql, I got same message. But if I run "\df to_char",
I
> > got the inform I want. Looks like psql can not showing too much data.
But
> > what this error message mean, and how to fix it?
>
> The frontend seems to use "less" (an improved "more") as a pager if more
> rows are returned than fit on one screen. Be sure to have "less"
> installed and in your PATH.
>