[postgis-users] ShapeFile Import

Chris Hermansen chris.hermansen at timberline.ca
Wed Jun 25 09:26:51 PDT 2008

Is the name of your shape file Public.Temp3.shp?  Try that.

As for the database, you probably need to add a password to your role.  
If memory serves, you would use the SQL command ALTER ROLE, so check 
that out in the PostgreSQL documentation.

Bob Pawley wrote:
> I am attempting to use the shapefile conversion/upload found in the 
> documents.
> shp2pgsql "dv99_00.shp" Public.Temp3 | psql -d Temp_
> If I understand correctly there is the shape file, the table to be 
> generated then the table to drop.
> However I get two problems.
> 1 - I get message that the shape files can not be opened.
> 2 - I'm asked for a password. When I enter the database password I get 
> message that the password was rejected - but in refernce to the name 
> of this computer - which has no password.
> If anyone can help I would appreciate it.
> Bob
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Chris Hermansen         mailto:chris.hermansen at timberline.ca
tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue  · Vancouver BC · Canada · V5Z 1E5

More information about the postgis-users mailing list