So far, we checked and imported the PRISM and SRTM rasters into the
chap5 schema of the
postgis_cookbook database. We will now proceed to work with the rasters within the database.
In this recipe, we explore functions that provide insight into the raster attributes and characteristics found in the
postgis_cookbook database. In doing so, we can see whether what is found in the database matches the information provided by
PostGIS includes the
raster_columns view to provide a high-level summary of all the raster columns found in the database. This view is similar to the
geography_columns views in function and form.
Let's run the following SQL ...