raster2pgsql Man page



raster2pgsql – 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 ta‐
ble. It is capable of loading folders of raster files as well as creat‐
ing 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 depen‐
dency 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 [] [ [ …]] [[.]


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


-s 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 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 Cut raster into tiles to be inserted one per

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

-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. Pro‐
vided 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 ta‐
ble 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 Specify the name of the raster column

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

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

-l Create overview of the raster. For more than

one factor, separate with comma(,). Overview table name follows
the pattern o__

. 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 use‐
ful 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 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 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 value to use on bands without a NODATA value.

-k Skip NODATA value checks for each raster band.

-E Control endianness of generated binary output of

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

-V 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_VAprilN2014 (r12389) RASTER2PGSQL(1)

Ils en parlent aussi

Loading raster data in PostGIS and visualising the results in QGIS …