The following bug has been logged online:
Bug reference: 3985
Logged by: srijit
Email address: srijit219@yahoo.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