[postgis-users] shp2pgsql not loading table in Postgis

[Stephen Crawford]

I have had the same problem; it seems having to add the password screws
things up.  Instead of making the sql and loading the table all in one step
(as you are trying to do), try it in two steps:
 
1) Make the sql:   shp2pgsql.exe -s 4148 c:\province.shp province >
province.sql
 
2) log in to psql and then use the \i command to load the table:  \i
province.sql
 
 
Steve
 
Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University
 

 


  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Intengu
Technologies
Sent: Thursday, February 28, 2008 1:47 PM
To: PostGIS Users Discussion
Subject: [postgis-users] shp2pgsql not loading table in Postgis



I am running Windows with Postgis 1.3.2 (installed using Appication Stack
Builder) on Postgresql 8.3 on running shp2pgsql.exe -s 4148 c:\province.shp
province | psql -d spatialdb -U username and then entering password, the
table is not loaded.  What could I be doing wrong.
-- 
Sindile Bidla 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080303/98995e5d/attachment.html>