<BODY><P>Dear all, </P>
<P>I'm a newby to PostGis and I'm getting some difficulties to setting up PostGis using the psql terminal. I installed Windows 8.1.4 compiled version from Postgres and Windows 1.1.3 compiled version from PostGIS. <BR>Using the example presented by Refractions on the document titled "Introduction to PostGIS" refering on how to create a table using psl terminal I get the following error: </P>
<P><BR>Welcome to psql 8.1.4, the PostgreSQL interactive terminal. </P>
<P>Type: \copyright for distribution terms <BR> \h for help with SQL commands <BR> \? for help with psql commands <BR> \g or terminate with semicolon to execute query <BR> \q to quit </P>
<P>Warning: Console code page (850) differs from Windows code page (1252) <BR> 8-bit characters may not work correctly. See psql reference <BR> page "Notes for Windows users" for details. </P>
<P><BR>postgres=# \c postgis <BR>You are now connected to database "postgis". <BR>postgis=# create table points ( pt geometry, name varchar ); <BR>CREATE TABLE <BR>postgis=# insert into points values ( 'POINT(0 0)', 'Origin' ); <BR>INSERT 0 1 <BR>postgis=# insert into points values ( 'POINT(5 0)', 'X Axis' ); <BR>INSERT 0 1 <BR>postgis=# insert into points values ( 'POINT(0 5)', 'Y Axis' ); <BR>INSERT 0 1 <BR>postgis=# select name, AsText (pt), Distance (pt, 'POINT(5 5) ') <BR>from points; <BR>'more' n'est pas reconnu en tant que commande interne <BR>ou externe, un programme exécutable ou un fichier de commandes. <BR>postgis=# </P>
<P><BR>I have been told that the psql terminal is configured to use the pager, 'more', so I should turn it off. Running the the following command on psql : \pset pager the terminal noticed that pager is setted to Off.</P>
<P>Any help about this issue would be appreciated.</P>
<P>Regards <BR><BR>Tahir Tamba <BR>MSc. Géographie <BR>Aménagement du territoire et SIG/ Gestion et conservation des ressources naturelles <BR>Télédétection-cartographie écologique, caractérisation des milieux humides <BR>Tel: (514) 526-7543 <BR>Courriel: tamba.tahir@courrier.uqam.ca <BR>--------------------------------------------------------- <BR>Tahir Tamba <BR>MSc. Geography <BR>Urban planning and GIS specialist/Natural resources management and conservation <BR>Remote-sensing-ecological mapping and wetland monitoring and Characterization <BR>Tel: (514) 526-7543 <BR>E-mail: tamba.tahir@courrier.uqam.ca <BR><BR><BR><BR></P></BODY>