Re: how to use PostGIS with Postgres

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Yantao Shi <y(dot)shi(at)larc(dot)nasa(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to use PostGIS with Postgres
Date: 2006-02-23 21:21:38
Message-ID: 20060223212138.GA86022@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-02-23 21:23:37 Re: PGPASSWORD
Previous Message Jim C. Nasby 2006-02-23 21:18:35 Re: 8.0.3 pg_autovacuum doesn't clear out stats table?