Thread: psql error

psql error

From
"PostgreSQL"
Date:
Hi,

My ISP has recently installed PostgreSQL and I started using it  a few days
ago. When issuing a SELECT command from inside 'psql' I get the following
behaviour:

When just a few rows are returned, then the output is shown normally on the
screen. When on the contrary my SELECT returns many rows, the following
message is output to the screen instead of the excpected output:

  more: not found

Any hints?

Paulo
pparola@brazilinfo.com




Re: [GENERAL] psql error

From
Bruce Momjian
Date:
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi,
>
> My ISP has recently installed PostgreSQL and I started using it  a few days
> ago. When issuing a SELECT command from inside 'psql' I get the following
> behaviour:
>
> When just a few rows are returned, then the output is shown normally on the
> screen. When on the contrary my SELECT returns many rows, the following
> message is output to the screen instead of the excpected output:
>
>   more: not found

You have PAGER environment variable defined to 'more', but do not have
'more' defined in your path.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026