Thread: how to use PostGIS with Postgres
We have PostGIS 1.1.1 installed and I am trying to get it to work with Postgres8.1.1 on our system. Could some one give me a small sample script that lets me connect to postgis from Postgres? I have never used postgis before. I need to test its geo-spatial functionality with Postgres. Thanks a lot, Yantao
On Thu, Feb 23, 2006 at 01:54:06PM -0500, Yantao Shi wrote: > We have PostGIS 1.1.1 installed and I am trying to get it to work with > Postgres8.1.1 on our system. > > Could some one give me a small sample script that lets me connect to > postgis from Postgres? > > I have never used postgis before. I need to test its geo-spatial > functionality with Postgres. PostGIS is just a set of extensions on top of PostgreSQL. As long as you don't create any namespace collisions, you can use a PostGIS database exactly the same as if it was just a PostgreSQL database (which of course it is). -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
On Thu, Feb 23, 2006 at 01:54:06PM -0500, Yantao Shi wrote: > We have PostGIS 1.1.1 installed and I am trying to get it to work with > Postgres8.1.1 on our system. > > Could some one give me a small sample script that lets me connect to > postgis from Postgres? PostGIS is a third-party extension to PostgreSQL; it's a set of data types, functions, and operators that you load into PostgreSQL and then use with ordinary SQL. It also has command-line programs for importing and exporting ESRI Shapefile data. See the PostGIS documentation for installation instructions and usage examples: http://postgis.refractions.net/docs/ I'd recommend subscribing to the postgis-users mailing list in addition to the PostgreSQL lists. The PostgreSQL lists are good for general help with the database, but the PostGIS list is better if you have PostGIS-specific questions. http://postgis.refractions.net/mailman/listinfo/postgis-users -- Michael Fuhr