getting contents of .shp file into postgre database; getting errors

[المشرف العام]

I’m having trouble getting a shapefile into the database. I’m trying to get in to work first by using shp2pgsql from cmd, but ultimately I want a python script to do it. I tried:shp2pgsql \\storage1\gis\output.shp -s 48425 -p 5432 -u timmyj myschema.mytableand it output screens of

162FD2641E8E7A09879740641806C312356FE2641F8A386BFEA73064180DC846 3B0740641B0AD911721002741F004B9C48C7506418CC581BD1E012741680EDCE 1280227419057FD3224760641E8ADB39DC7022741D85F58969C760641'); COMMIT;

​

And nothing appears in the database. It also didn’t ask for a password. I also tried

shp2pgsql \\storage1\gis\output.shp -s 48425 -p 5432 -u timmyj myschema.mytable| psql -U postgres

and then enter the password but it gives a ton of

ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK

​

How do I get the .shp file into the Postgres db?



أكثر...