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