<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2>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:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2>1) Make the sql: <FONT face="Times New Roman"
size=3>shp2pgsql.exe -s 4148 c:\province.shp province >
province.sql</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2>2) log in to psql and then use the \i command to load the table: \i
province.sql</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2>Steve</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=580255619-03032008><!-- Converted from text/plain format -->
<P><FONT face=Tahoma size=2>Stephen Crawford<BR>Center for Environmental
Informatics<BR>The Pennsylvania State University<BR></FONT></SPAN><SPAN
class=580255619-03032008><FONT face=Tahoma size=2> </FONT></SPAN></P>
<P><SPAN class=580255619-03032008> </SPAN></P>
<P>
<HR tabIndex=-1>
</P>
<P><FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Intengu Technologies<BR><B>Sent:</B> Thursday, February 28, 2008 1:47
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users]
shp2pgsql not loading table in Postgis<BR></FONT><BR></P></DIV>
<DIV></DIV>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.<BR>--
<BR>Sindile Bidla </BODY></HTML>