Re: how to use PostGIS with Postgres - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: how to use PostGIS with Postgres
Date
Msg-id 20060223212138.GA86022@pervasive.com
Whole thread Raw
In response to how to use PostGIS with Postgres  (Yantao Shi <y.shi@larc.nasa.gov>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PGPASSWORD