NAME

       pgsql2shp - postgis to shapefile dumper

SYNTAX

       pgsql2shp [options] database [schema.]table
       pgsql2shp [options] database query

DESCRIPTION

       The  pgsql2shp  table  dumper connects directly to the database and converts a table (possibly created by
       user query) into a shape file. It is compatible with all versions of PostGIS.

       Version: 1.1.5 (2006/10/06)

USAGE

       The <database> is the name of the database to connect to.

       The <table> is the (optionally schema-qualified) table to read spatial data from. Alternatively, you  can
       specify a QUERY whose result will be written into the shapefile.

OPTIONS

       The commandline options are:

       -f <filename>
              Write the output to a particular filename.

       -h <host>
              The database host to connect to.

       -p <port>
              The port to connect to on the database host.

       -P <password>
              The password to use when connecting to the database.

       -u <user>
              The username to use when connecting to the database.

       -g <geometry column>
              In  the case of tables with multiple geometry columns, the geometry column to use when writing the
              shape file.

       -b     Use a binary cursor. When used on pre-1.0.0 PostGIS versions this will reduce  the  likelihood  of
              coordinate  drift  due to conversion to and from WKT format. Coordinate drifts will not occur with
              PostGIS 1.0.0 and newer versions. It will be slightly faster, but might fail if  any  NON-geometry
              column lacks a cast to text.

       -r     Raw mode. Do not drop the gid field, or escape column names.

       -d     For  backward  compatibility:  write  a 3-dimensional shape file when dumping from old (pre-1.0.0)
              postgis databases (the default is to write a 2-dimensional shape file in that case). Starting from
              postgis-1.0.0+, dimensions are fully encoded.

       -k     Keep identifiers case (don't uppercase field names).

       -m <filename>
              Specify a file containing a set of mappings of (long) column names  to  10  character  DBF  column
              names.  The  content of the file is one or more lines of two names separated by white space and no
              trailing or leading space:

              COLUMNNAME DBFFIELD1\n
              AVERYLONGCOLUMNNAME DBFFIELD2\n

              etc.

       -?     Display version and usage information.

INSTALLATION

       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 systems.

EXAMPLES

       An example session using the dumper to create shape file from a database might look like this:

       # pgsql2shp -f myfile -p 5555 my_db roads_table

AUTHORS

       Originally written by Jeff Lounsbury  <jeffloun@refractions.net>.   Improved  and  maintained  by  Sandro
       Santilli <strk@kbt.io>.  Includes small contributions and improvements by others.

       This  application uses functionality from shapelib 1.2.9 by Frank Warmerdam <warmerda@gdal.velocet.ca> to
       write to ESRI Shape files.

SEE ALSO

       shp2pgsql(1)

       More information is available at http://postgis.net

                                                                                                    pgsql2shp(1)