[postgis-users] shp2pgsql problem with Leopard

David Garbin dgarbin at verizon.net
Sun Dec 30 08:48:29 PST 2007


I am using PostgreSQL/Postgis with Leopard using the latest Kyng Chaos  
binaries.  Everything appears to be working well except shp2pgsql.   
When I try to load a shapefile, it just gives me the help screen (see  
below):

[Big-Mac:~] dgarbin% /usr/local/pgsql/bin/shp2pgsql -D -s 4269 -i -I / 
Users/dgarbin/grass/Shapefiles/dtl_cnty.shp dgarbin.dtl_cnty | /usr/ 
local/pgsql/bin/psql -d networx
RCSID: $Id: shp2pgsql.c 2717 2007-11-23 10:42:09Z mcayland $ RELEASE:  
1.3.2
USAGE: /usr/local/pgsql/bin/shp2pgsql [<options>] <shapefile>  
[<schema>.]<table>
OPTIONS:
   -s <srid>  Set the SRID field. If not specified it defaults to -1.
   (-d|a|c|p) These are mutually exclusive options:
       -d  Drops the table, then recreates it and populates
           it with current shape file data.
       -a  Appends shape file into current table, must be
           exactly the same table schema.
       -c  Creates a new table and populates it, this is the
           default if you do not specify any options.
       -p  Prepare mode, only creates the table.
   -g <geometry_column> Specify the name of the geometry column
      (mostly useful in append mode).
   -D  Use postgresql dump format (defaults to sql insert statments.
   -k  Keep postgresql identifiers case.
   -i  Use int4 type for all integer dbf fields.
   -I  Create a GiST index on the geometry column.
   -S  Generate simple geometries instead of MULTI geometries.
   -w  Use wkt format (for postgis-0.x support - drops M - drifts  
coordinates).
   -W <encoding> Specify the character encoding of Shape's
      attribute column. (default : "ASCII")
   -N <policy> Specify NULL geometries handling policy  
(insert,skip,abort)
   -? Display this help screen
[Big-Mac:~] dgarbin%


There seems to be a problem reading parameters.  If I just specify the  
-? option, it says "No match".



More information about the postgis-users mailing list