Thread: shp2pgsql in java
Hello,
I am new in this list.
Sorry for my worse english.
I have a problem, and I didn't find a answer in the Internet.
I will use the command shp2pgsql from a java programm to import shapefiles in a postgresql DB, but I can't find some examples.
Can anybody help me, or have anybody an example how this work? or a documentation?
Thank you for your answer.
Regards,
Melanie
I am new in this list.
Sorry for my worse english.
I have a problem, and I didn't find a answer in the Internet.
I will use the command shp2pgsql from a java programm to import shapefiles in a postgresql DB, but I can't find some examples.
Can anybody help me, or have anybody an example how this work? or a documentation?
Thank you for your answer.
Regards,
Melanie
2009/9/18 Melanie Hofmann <melanie.hofmann20@googlemail.com>: > Hello, > > I am new in this list. > Sorry for my worse english. > > I have a problem, and I didn't find a answer in the Internet. > > I will use the command shp2pgsql from a java programm to import shapefiles > in a postgresql DB, but I can't find some examples. > > Can anybody help me, or have anybody an example how this work? or a > documentation? > > Thank you for your answer. I think you basically want to set up a shell pipeline from Java. You could either execute shp2pgsql from Java and arrange for its stdout file descriptor to be pointing at a file and then execute psql to read from that same file, or you could do it in one step by connecting the stdout of shp2pgsql to the stdin of psql. From Python, this is one way to do it. (It should work from Jython too, I think): http://docs.python.org/library/subprocess.html#replacing-shell-pipeline From Java you might find something useful here: http://www.google.co.za/search?q=java+execute+shell+command -- Michael Wood <esiotrot@gmail.com>