The following bug has been logged online: Bug reference: 3985 Logged by: srijit Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend