raster2pgsql(1) loads GDAL supported raster formats into a PostGIS raster table


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.


raster2pgsql [<options>] <raster>[ <raster>[ ...]] [[<schema>.]<table>]
Multiple rasters can also be specified using wildcards (*,?).


-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.
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:
Drops the table, then recreates it and populates it with current raster data.
Appends raster into current table, must be exactly the same table schema.
Creates a new table and populates it, this is the default if you do not specify any options.
Prepare mode, only creates the table.
-f <column> Specify the name of the raster column
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.
Wrap PostgreSQL identifiers in quotes.
Create a GIST spatial index on the raster column. The ANALYZE command will automatically be issued for the created index.
Run VACUUM ANALYZE on the table of the raster column. Most useful when appending raster to existing table with -a.
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.
Disable setting the max extent constraint. Only applied if -C flag is also used.
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.
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.
Execute each statement individually, do not use a transaction.
Use COPY statements instead of INSERT statements.
Print the supported GDAL raster formats.
Display the help screen.