NAME

       raster2pgsql - loads GDAL supported raster formats into a PostGIS raster table

DESCRIPTION

       raster2pgsql  is  a raster loader executable that loads GDAL supported raster formats into
       sql suitable for loading into a PostGIS raster table. It is capable of loading folders  of
       raster files as well as creating overviews of rasters.

       Since  the raster2pgsql is compiled as part of PostGIS most often (unless you compile your
       own GDAL library), the raster types supported by the executable will be the same as  those
       compiled  in  the  GDAL  dependency library. To get a list of raster types your particular
       raster2pgsql supports use the -G switch. These should be the same  as  those  provided  by
       your PostGIS install documented here ST_GDALDrivers if you are using the same gdal library
       for both.

SYNOPTIS

       raster2pgsql [<options>] <raster>[ <raster>[ ...]] [[<schema>.]<table>]

       Multiple rasters can also be specified using wildcards (*,?).

OPTIONS

       -s <srid> Set the raster's SRID. Defaults to 0. If SRID not

              provided or is 0, raster's metadata will be checked  to  determine  an  appropriate
              SRID.

       -b <band> Index (1-based) of band to extract from raster. For more

              than  one  band index, separate with comma (,). Ranges can be defined by separating
              with dash (-). If unspecified, all bands of raster will be extracted.

       -t <tile size> Cut raster into tiles to be inserted one per

              table row. <tile size> is expressed as  WIDTHxHEIGHT.   <tile  size>  can  also  be
              "auto"  to  allow  the  loader  to compute an appropriate tile size using the first
              raster and applied to all rasters.

       -P Pad right-most and bottom-most tiles to guarantee that all tiles

              have the same width and height.

       -R     Register the raster as an out-of-db (filesystem)  raster.  Provided  raster  should
              have absolute path to the file

              (-d|a|c|p) These are mutually exclusive options:

       -d     Drops the table, then recreates it and populates it with current raster data.

       -a     Appends raster 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.

       -f <column> Specify the name of the raster column

       -F     Add a column with the filename of the raster.

       -n <column> Specify the name of the filename column. Implies -F.

       -l <overview factor> Create overview of the raster. For more than

              one factor, separate  with  comma(,).  Overview  table  name  follows  the  pattern
              o_<overview  factor>_<table>. Created overview is stored in the database and is not
              affected by -R.

       -q     Wrap PostgreSQL identifiers in quotes.

       -I     Create a GIST spatial  index  on  the  raster  column.  The  ANALYZE  command  will
              automatically be issued for the created index.

       -M     Run  VACUUM  ANALYZE  on the table of the raster column. Most useful when appending
              raster to existing table with -a.

       -C     Set the standard set of constraints on the raster  column  after  the  rasters  are
              loaded. Some constraints may fail if one or more rasters violate the constraint.

       -x     Disable setting the max extent constraint. Only applied if -C flag is also used.

       -r     Set the constraints (spatially unique and coverage tile) for regular blocking. Only
              applied if -C flag is also used.

       -T <tablespace> Specify the tablespace for the new table.

              Note that indices (including the primary key) will still use the default tablespace
              unless the -X flag is also used.

       -X <tablespace> Specify the tablespace for the table's new index.

              This applies to the primary key and the spatial index if the -I flag is used.

       -N <nodata> NODATA value to use on bands without a NODATA value.

       -k     Skip NODATA value checks for each raster band.

       -E <endian> Control endianness of generated binary output of

              raster. Use 0 for XDR and 1 for NDR (default). Only NDR is supported at this time.

       -V <version> Specify version of output WKB format. Default

              is 0. Only 0 is supported at this time.

       -e     Execute each statement individually, do not use a transaction.

       -Y     Use COPY statements instead of INSERT statements.

       -G     Print the supported GDAL raster formats.

       -?     Display the help screen.

raster2pgsql RELEASE: 2.1.2 GDAL_VERSION=110April32014                            RASTER2PGSQL(1)