In addition to that, using the latest release of Postgres I had to rename<br>libiconv2.dll to libiconv-2.dll in order to use shp2pgsql in Windows Vista.<br>Whitout renaming, shp2pgsql crashes on this dll<br><br>Steven<br><br>
<div class="gmail_quote">On Mon, Mar 3, 2008 at 8:21 PM, Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Sometimes the pipe operation ain't great on Windows, try doing it in two steps<br>
<br>
shp2psql > file.sql<br>
psql -f file.sql<br>
<div><div></div><div class="Wj3C7c"><br>
On 2/28/08, Intengu Technologies <<a href="mailto:sindile.bidla@gmail.com">sindile.bidla@gmail.com</a>> wrote:<br>
> I am running Windows with Postgis 1.3.2 (installed using Appication Stack<br>
> Builder) on Postgresql 8.3 on running shp2pgsql.exe -s 4148 c:\province.shp<br>
> province | psql -d spatialdb -U username and then entering password, the<br>
> table is not loaded. What could I be doing wrong.<br>
> --<br>
> Sindile Bidla<br>
</div></div>> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br>