This topic describes how to load a raster data file from your computer or an Object Storage Service (OSS) bucket into Ganos by using the ST_ImportFrom function.
Prerequisites
Your AnalyticDB for PostgreSQL instance is authorized to access the raster data file. If the raster data file is stored in an OSS bucket, your AnalyticDB for PostgreSQL instance is deployed in the same region as the OSS bucket. For more information, see OSS domain names.
ST_ImportFrom
The ST_ImportFrom function is used to load a raster data file from your computer or an OSS bucket into Ganos.
Note
- In addition to the ST_ImportFrom function, Ganos 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>'))