[postgis-users] Database connection in postgresql

Angel Joyce joys.tower at gmail.com
Wed Mar 4 07:17:26 PST 2009


For de second question you can use shp2pgsql to insert the shape file into
postgis table

for example:

#  create table and generate a index for the geometry column
bash$ shp2pgsql -c -I shapefile eschema.table > file.sql

#  upload the data to the postgis databse
bash$ psql -d database -f file.sql

sql2pgsql command is installed in the default installation of postgis

sorry for *my *english
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090304/71158659/attachment.html>


More information about the postgis-users mailing list