[postgis-users] shp2pgsql not loading table in Postgis

[Burgholzer,Robert]

I do this by setting PGPASSWD, since you may want to do this in an
unsupervised mode from a shell script:

 

PGPASSWORD=$pgpasswd

 

Works for me using the GNU tools for windows bash shell, and in bash on
linux and OSX.

 

Robert W. Burgholzer

Surface Water Modeler

Office of Water Supply and Planning

Virginia Department of Environmental Quality

rwburgholzer at deq.virginia.gov

804-698-4405

Open Source Modeling Tools:

http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Stephen Crawford
Sent: Monday, March 03, 2008 3:02 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] shp2pgsql not loading table in Postgis

 

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/e5e7d64e/attachment.html>