Re: [postgis-users] import shape or sql to postgres automatically

.cave-ayl...@siriusit.co.uk > To: postgis-users@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 >

Re: [postgis-users] import shape or sql to postgres automatically

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

Re: [postgis-users] import shape or sql to postgres automatically

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 po

Re: [postgis-users] import shape or sql to postgres automatically

ostgis-users] 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 > >

Re: [postgis-users] import shape or sql to postgres automatically

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 t

Re: [postgis-users] import shape or sql to postgres automatically

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 start

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 to terminal in linux, and go to the directory C:/users C:/users shp2pgsql shapefile.shp > sqlfile.sql I will get sql

[postgis-users] 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 shapefile.shp > sqlfile.sql I will get sql file saved into c