This topic describes how to load a raster data file from your computer or an Alibaba Cloud Object Storage Service (OSS) to GanosBase by using the ST_ImportFrom function.
Precautions
Your instance is authorized to access the raster data file. If the raster data file is stored in an OSS bucket, your instance resides in the same region as the OSS bucket. For more information, see OSS domain names.
Introduction to the ST_ImportFrom function
The ST_ImportFrom function is used to load a raster data file from your computer or an OSS bucket to GanosBase.
In addition to the ST_ImportFrom function, GanosBase provides other raster-related functions. For more information, see Raster SQL Reference.
For more information about the parameters in the ST_ImportFrom function, see ST_ImportFrom.
Syntax
INSERT INTO <raster_table_name>(<raster_column_name>) VALUES (ST_IMPORTFROM('<chunk_table_name>','<path_to_raster_file>'))Examples
Create the ganos_raster extension.
CREATE EXTENSION Ganos_Raster CASCADELoad a raster data file from your computer to GanosBase.
INSERT INTO raster_table(name, rast) VALUES ('local_file', ST_ImportFrom('chunk_table', '/home/beijing.tif'));Load a raster data file from an OSS bucket to GanosBase.
INSERT INTO raster_table(name, rast) VALUES ('oss_file', ST_ImportFrom('chunk_table', 'oss://ak:as@bucket/data/beijing.tif'));