[postgis-users] shp2pgsql question

[Burgholzer,Robert]

Dana,
You can also run it in the manner that you are, i.e., exporting the
output to a file.  I am curious, what does the script output look like
if you run it without dumping it to a file, i.e.:
c:/shp2pgsql -s 26912 -p c:/Jordyn Jordyn 

Whatever error message it dumps should be useful.

Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
rwburgholzer at deq.virginia.gov
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Nandorov
Sent: Friday, November 07, 2008 3:26 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] shp2pgsql question


Dana:

inside your postgis bin directory you have to run:

shp2pgsql [options] [shape file] [schema][table] | psql [database]

for example:

shp2pgsql C:\shp\myshape.shp public.test_shp | psql mydatabase

maybe it will be more helpfull:
http://postgis.refractions.net/documentation/manual-1.3/ch04.html#id2868
133

Hope it helps,
Regards


Dana Lee wrote:
> 
> Hi,
> 
>  
> 
> I'm new to PostGIS and am having troubles running shp2pgsql. When I
run
> the
> command below nothing happens, there is not Jordyn.sql file in my C
drive.
> I've copied the shp2pgsql.exe and shapefile to my C drive and changed
my
> current directory to my C drive, then tried running the command with
and
> without the c:/ but nothing ever happens. I'm not sure what I'm doing
> wrong.
> Any help or advice would be greatly appreciated. Thanks.
> 
>  
> 
> c:/shp2pgsql -s 26912 -p c:/Jordyn Jordyn > c:/Jordyn.sql
> 
>  
> 
> Dana
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context:
http://www.nabble.com/shp2pgsql-question-tp20387316p20388273.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users