No the shape file is "dv99_00.shp" - Public.Temp3 is the name of the schema and table I want to create for the shape information. At least that's my understanding.

Bob

----- Original Message ----- From: "Chris Hermansen" <[EMAIL PROTECTED]>
To: "PostGIS Users Discussion" <[email protected]>
Sent: Wednesday, June 25, 2008 9:26 AM
Subject: Re: [postgis-users] ShapeFile Import


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

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to