[postgis-users] ShapeFile Import

[Bob Pawley]

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" <chris.hermansen at timberline.ca>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> -- 
> Regards,
>
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users