[postgis-users] ShapeFile Import
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
> 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.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
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