Provided by: postgis_1.5.1-5_i386 bug


       shp2pgsql - shapefile to postgis loader


       shp2pgsql [options] shapefile [schema.]table


       The  shp2pgsql  data loader converts ESRI Shape files into SQL suitable
       for insertion into a PostGIS/PostgreSQL database.

       Version: 1.1.5 (2006/10/06)


       The <shapefile> is the name of the shape file,  without  any  extension
       information.  For  example,  'roads' would be the name of the shapefile
       comprising the 'roads.shp', 'roads.shx', and 'roads.dbf' files.

       The <tablename>  is  the  (optionally  schema-qualified)  name  of  the
       database table you want the data stored in in the database. Within that
       table, the geometry  will  be  placed  in  the  'geo_value'  column  by


       The  loader  has  several operating modes distinguished by command line

       (Note that -a, -c, -d and -p are mutually exclusive.)

       -d     Drops the database table before creating a new  table  with  the
              data in the Shape file.

       -a     Appends  data  from the Shape file into the database table. Note
              that to use this option to load multiple files, the  files  must
              have the same attributes and same data types.

       -c     Creates  a  new table and populates it from the Shape file. This
              is the default mode.

       -p     Only produces the table creation SQL code,  without  adding  any
              actual  data.   This  can  be  used  if  you  need to completely
              separate the table creation and data loading steps.

       -D     Use the PostgreSQL "dump" format for the output data.  This  can
              be  combined  with -a, -c and -d. It is much faster to load than
              the default "insert" SQL format. Use this for  very  large  data

       -s <SRID>
              Creates  and  populates  the  geometry tables with the specified

       -g <geometry_column>
              Specify the name of the geometry column (mostly useful in append

       -k     Keep idendifiers case (column, schema and attributes). Note that
              attributes in Shapefile are usually all UPPERCASE.

       -i     Coerce all integers to standard 32-bit integers, do  not  create
              64-bit  bigints,  even  if  the  DBF header signature appears to
              warrant it.

       -S     Generate simple Geometries  instead  of  MULTIgeometries.  Shape
              files  don't differ between LINESTRINGs and MULTILINESTRINGs, so
              shp2pgsql generates MULTILINESTRINGs  by  default.  This  switch
              will  produce  LINESTRINGs instead, but shp2pgsql will fail when
              it hits a real MULTILINESTRING. The same works for POLYGONs  vs.

       -w     Output WKT format, for use with older (0.x) versions of PostGIS.
              Note that this will introduce coordinate drifts and will drop  M
              values from shapefiles.

       -W <encoding>
              Specify  the  character  encoding of Shapefile's attributes.  If
              this option is used the output will be encoded in UTF-8.

       -I     Create a GiST index on the geometry column.

       -N <policy>
              Specify NULL geometries handling policy (insert,skip,abort).

       -?     Display version and usage information.


       To compile the program from source, simply run  "make"  in  the  source
       directory.  Then copy the binary in your shell search path (or wherever
       you like). This text is also available as a man page in the ../doc/man/
       directory,  ready for copying it into the manual search path on unixoid


       An example session using  the  loader  to  create  an  input  file  and
       uploading it might look like this:

       # shp2pgsql shaperoads roadstable roadsdb > roads.sql
       # psql -d roadsdb -f roads.sql

       A conversion and upload can be done all in one step using UNIX pipes:

       # shp2pgsql shaperoads roadstable roadsdb | psql -d roadsdb


       Originally   written   by  Jeff  Lounsbury  <>.
       Improved and  maintained  by  Sandro  Santilli  <>.
       Includes small contributions and improvements by others.

       This  application  uses  functionality  from  shapelib  1.2.9  by Frank
       Warmerdam <> to read from ESRI Shape files.



       More information is available at