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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
