This applies to the primary key and the spatial index if the Specify the tablespace for the table's new index. The default tablespace unless the -X flag is also used. Note that indices (including the primary key) will still use Specify the tablespace for the new table. Specify name of destination raster column, default is 'rast'Īdd a column with the name of the file -IĬreate a GiST index on the raster column. Optional parameters used to manipulate database objects NODATA value to use on bands without a NODATA value. Note that your generated sql file will contain both the main table and overview tables. Stored in the database and is not affected by -R. The pattern o_ overview factor_ table, where overview factor is a placeholder for numerical overview factor and table is replaced with the base table name. l OVERVIEW_FACTORĬreate overview of the raster.

Only the metadata of the raster and path location to the raster is stored in the database (not the pixels). Register the raster as a filesystem (out-db) raster. TILE_SIZE is expressed as WIDTHxHEIGHT or set to the value 'auto' to allow the loader to compute an appropriate tile size using the first raster and applied to all rasters. If unspecified,Ĭut raster into tiles to be inserted one per table row. For more than one band index, separate with comma (,). Index (1-based) of band to extract from raster. If not provided or is zero, raster's metadata will be checked to determine an appropriate SRID.

Assign output raster with specified SRID.

Download Data File Converter 5.3.4