[postgis-users] PostGIS configuration on WinXP issue using psqlterminal

[Obe, Regina]

Have you tried using the PgAdmin tool that comes prepackaged with the PostGreSQL installation.  I find it in general a bit easier to use than psql and limit my psql use for automated jobs, loading of sql batch files and things of that sort.
 
At the very list if you run into similar problems using the PgAdmin query tool part, it may give you more clues as to what is wrong with your install.
 
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Tahir Tamba
Sent: Thu 10/12/2006 5:40 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] PostGIS configuration on WinXP issue using psqlterminal



Dear all, 

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. 
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: 


Welcome to psql 8.1.4, the PostgreSQL interactive terminal. 

Type:  \copyright for distribution terms 
        \h for help with SQL commands 
        \? for help with psql commands 
        \g or terminate with semicolon to execute query 
        \q to quit 

Warning: Console code page (850) differs from Windows code page (1252) 
          8-bit characters may not work correctly. See psql reference 
          page "Notes for Windows users" for details. 


postgres=# \c postgis 
You are now connected to database "postgis". 
postgis=# create table points ( pt geometry, name varchar ); 
CREATE TABLE 
postgis=# insert into points values ( 'POINT(0 0)', 'Origin' ); 
INSERT 0 1 
postgis=# insert into points values ( 'POINT(5 0)', 'X Axis' ); 
INSERT 0 1 
postgis=# insert into points values ( 'POINT(0 5)', 'Y Axis' ); 
INSERT 0 1 
postgis=# select name, AsText (pt), Distance (pt, 'POINT(5 5) ')  
from points; 
'more' n'est pas reconnu en tant que commande interne 
ou externe, un programme exécutable ou un fichier de commandes. 
postgis=# 


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.

Any help about this issue would be appreciated.

Regards 

Tahir Tamba 
MSc. Géographie 
Aménagement du territoire et SIG/ Gestion et conservation des ressources naturelles 
Télédétection-cartographie écologique, caractérisation des milieux humides 
Tel: (514) 526-7543 
Courriel: tamba.tahir at courrier.uqam.ca 
--------------------------------------------------------- 
Tahir Tamba 
MSc. Geography 
Urban planning and GIS specialist/Natural resources management and conservation 
Remote-sensing-ecological mapping and wetland monitoring and Characterization 
Tel: (514) 526-7543 
E-mail: tamba.tahir at courrier.uqam.ca 








-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 5988 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061013/7773fd46/attachment.bin>