Jeff Lounsbury jeffloun at refractions.net
Tue Sep 9 14:53:36 PDT 2003

As far as your second point, shp2pgsql doesn't connect directly to the
DB, it just outputs SQL. So you need to either pipe it into psql
./shape2pgsql -D db /var/www/cgi-bin/atlas/data/states_nlam.shp states
db  |  psql db

or else write it to a file that you can then use to load into postgres,
./shape2pgsql -D db /var/www/cgi-bin/atlas/data/states_nlam.shp states
db  > states_nlam.sql
psql db -f states_nlam.sql


"Menke, Kurt" wrote:

>  I am trying to familiarize myself with POSTGIS syntax and am hitting
> some barriers. I'm sure there is something basic I am missing.  Any
> help would be greatly appreciated1) Is Geometry still a valid data
> type?  I am working on a POSTGIS tutorial and if I use the SELECT
> command below SELECT AddGeometryColumn ( 'db', 'table', 'field', -1,
> 'GEOMETRY', 2 ) ;I get:Invalid Type name - valid ones are: GEOMETRY,
> LINESTRING, MULTILINESTRIN2) I hit another roadblock when trying to
> use the shp2pgsql command.When I try to dump a shapefile into a new
> tabel using:./shape2pgsql -D db
> /var/www/cgi-bin/atlas/data/states_nlam.shp states dbI get a series of
> coordinates printing to the screen but the table is not created.
> What am I doing wrong?Thanks,Kurt~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Kurt A. Menke
> GIS Analyst
> Earth Data Analysis Center
> The University of New Mexico
> Bandelier West, Room 111
> Albuquerque, NM 87131-6031
> (505)277-3622 ext. 239
> Fax (505)277-3614

  From MAILER-DAEMON  Tue Sep  9 14:54:24 2003
Return-Path: <>
Delivered-To: postgis-users at offsite.refractions.net
Received: from GWOUT.thalesgroup.com (gwout.thalesgroup.com [])
	by offsite.refractions.net (Postfix) with ESMTP id 39C55437B4
	for <postgis-users at postgis.refractions.net>;
	Tue,  9 Sep 2003 14:54:24 -0700 (PDT)
Received: from thalescan.corp.thales ( by GWOUT.thalesgroup.com
	(NPlex 6.5.026)
	id 3F4C863C000BF3A2 for postgis-users at postgis.refractions.net;
	Tue, 9 Sep 2003 23:57:15 +0200
Received: from lowplex.mut.thales ([]) by thalescan with InterScan
	Messaging Security Suite; Tue, 09 Sep 2003 23:54:24 +0200
Received: from tisplex.tisfr.thales ( by lowplex.mut.thales (NPlex
	id 3F52DE2100070ED0 for postgis-users at postgis.refractions.net;
	Wed, 10 Sep 2003 00:02:05 +0200
Received: from tisplex.tisfr.thales ( by tisplex.tisfr.thales (NPlex
	id 3F5C42BB00013C45 for postgis-users at postgis.refractions.net;
	Tue, 9 Sep 2003 23:54:24 +0200
Received: by sysecaplex.velizy.syseca (NPlex 6.5.026) id 3F52D43000026675 for
	postgis-users at postgis.refractions.net; Tue, 9 Sep 2003 23:54:24 +0200
From: cedric.bernier at thales-is.com
Subject: Re: [postgis-users]
To: postgis-users at postgis.refractions.net
Date: Tue, 9 Sep 2003 23:54:24 +0200
Message-ID: <3F52D43000026674 at sysecaplex.velizy.syseca>
In-Reply-To: <3F5E4BE0.1D1B3C86 at refractions.net>
Precedence: junk
Delivered-To: cedric.bernier at thales-is.com
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
X-BeenThere: postgis-users at postgis.refractions.net
X-Mailman-Version: 2.1b4
Reply-To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
List-Id: PostGIS Users Discussion <postgis-users.postgis.refractions.net>
List-Post: <mailto:postgis-users at postgis.refractions.net>
List-Subscribe: <http://postgis.refractions.net/mailman/listinfo/postgis-users>,
	<mailto:postgis-users-request at postgis.refractions.net?subject=subscribe>
List-Unsubscribe: <http://postgis.refractions.net/mailman/listinfo/postgis-users>,
	<mailto:postgis-users-request at postgis.refractions.net?subject=unsubscribe>
List-Archive: <http://lists.refractions.net/pipermail/postgis-users>
List-Help: <mailto:postgis-users-request at postgis.refractions.net?subject=help>
X-List-Received-Date: Tue, 09 Sep 2003 21:54:24 -0000

  -----  The following is an automated response=0D
  -----  to your message generated on behalf of cedric.bernier at thales-is.=

Actuellement en mission =E0 l'=E9tranger, je suis indisponible du 7 Septe=
mbre au 8 Octobre 2003 .

More information about the postgis-users mailing list