X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C4FEF9DCAD4 for ; Thu, 23 Feb 2006 14:54:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46978-07 for ; Thu, 23 Feb 2006 14:54:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from l0isi08.larcb.ecs.nasa.gov (l0isi08u.ecs.nasa.gov [129.165.226.2]) by postgresql.org (Postfix) with ESMTP id 885849DCA83 for ; Thu, 23 Feb 2006 14:54:11 -0400 (AST) Received: (from hermes@localhost) by l0isi08.larcb.ecs.nasa.gov (AIX5.1/8.11.6p2/8.11.0) id k1NItTW3792970 for ; Thu, 23 Feb 2006 13:55:29 -0500 X-Authentication-Warning: l0isi08.larcb.ecs.nasa.gov: hermes set sender to using -f Received: by larcb.ecs.nasa.gov via smwrap Version 5.1.5 id smwrapbZMiEa; Thu Feb 23 13:55:28 2006 Message-ID: <43FE04CE.5090502@larcb.ecs.nasa.gov> Date: Thu, 23 Feb 2006 13:54:06 -0500 From: Yantao Shi User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) MIME-Version: 1.0 To: Subject: how to use PostGIS with Postgres Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096] X-Spam-Score: 0.096 X-Spam-Level: X-Archive-Number: 200602/282 X-Sequence-Number: 20703 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