PostGIS 2.0 now has full support for raster datasets, and it is possible to import raster datasets using the
In this recipe, you will import a raster file to PostGIS using the
raster2pgsql command. This command, included in any PostGIS distribution from Version 2.0 onward, is able to generate an sql dump to be loaded in PostGIS for any GDAL raster-supported format (in the same fashion that the command
shp2pgsql does for shapefiles).
After loading the raster to PostGIS, you will inspect it both with SQL commands (analyzing the raster metadata information contained in the database), and with the
gdalinfo command-line utility (to understand the way the input