Re: BUG #3985: select command not working

On Sun, Feb 24, 2008 at 12:05:36PM +0000, srijit wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3985
> Logged by: srijit
> Email address: srijit219(at)yahoo(dot)com
> PostgreSQL version: 8.1
> Operating system: windows xp sp2
> Description: select command not working
> Details:
>
> i`ve installed Postgresql 8.1.....i`m able to create databases and tables
> but wen i try to view the contents of a table i get a message called "more
> is not a recognised internal command"., this has happened in many of my
> friends PCs also..... i request u to kindly give us a solution to this
> prob.....
>
> i`ve used the following statements
>
> create user srijit with password 'admin';
> CREATE ROLE
>
> create database mydb owner srijit;
> DATABASE CREATED
>
> \c mydb srijit;
> password for srijit:admin
>
> create table tab1(sno integer);
> table created
>
> insert into tab1 values(10);
> INSERT 0 1
>
> select * from tab1;
> 'more' is not a recognised internal or external command

That's interesting, indeed. AFAIK all windows versions ever has had a
more.com available - it shuold bei n your SYSTEM32 directory. Please check
if it's there, and if it could be the permissions on the file that are
somehow broken?

If you don't have it or it's somehow broken in a differnt way, you can run
the command:
\pset pager

in psql, to turn off the usage of the pager. You'll then of course not get
a pager, but you should get your data.

//Magnus