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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461