@postgis.refractions.net
Subject: Re: [postgis-users] import shape or sql to postgres automatically
zhang zhe wrote:
Hello,
Does anyone know how to import sql table or shape file to postgres
database automatically?
What I did before is:
I have shpe file save in C:/users
I go
] import shape or sql to postgres automatically
Hello,
Does anyone know how to import sql table or shape file to postgres
database automatically?
What I did before is:
I have shpe file save in C:/users
I go to terminal in linux, and go to the directory C:/users
C:/users shp2pgsql
zhang zhe wrote:
Hello,
Thanks. Actually, I have windows and apache server installed in my
computer. In this case how the code should look like?
What´s the mylinuxserver ? is it the IP adress of the server? or name of
the server?
Will my code changed into
psql.exe -h mywindowsServer -d
you have any idea how to do this?
Date: Mon, 13 Dec 2010 12:28:20 +
From: robertdbuck...@yahoo.com
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] import shape or sql to postgres automatically
Hi,
I find it easyest with the built in GUI from the opengeosuite. You
zhang zhe wrote:
Hello,
Does anyone know how to import sql table or shape file to postgres
database automatically?
What I did before is:
I have shpe file save in C:/users
I go to terminal in linux, and go to the directory C:/users
C:/users shp2pgsql shapefile.shp sqlfile.sql
I will get sql
Hi,
I find it easyest with the built in GUI from the opengeosuite. You can download
the community edition and use the whole Shape2postgis import tool as part of
the
deal
here is the link to the download.
http://opengeo.org/community/suite/download/
Simply install the desktop version and
Can you not just pipe it in : (from the manual)
shp2pgsql shaperoads.shp myschema.roadstable | psql -d roadsdb
or use the \i metacommand to run the created script.
cheers
Ben
On 13/12/2010, at 10:22 PM, zhang zhe wrote:
Hello,
Does anyone know how to import sql table or shape file to
