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>'))

Examples

  1. Create the ganos_raster extension.
    CREATE EXTENSION Ganos_Raster CASCADE
  2. Load a raster data file from your computer into Ganos.
    INSERT INTO raster_table(name, rast) VALUES ('local_file', ST_ImportFrom('chunk_table', '/home/beijing.tif'));
  3. Load a raster data file from an OSS bucket into Ganos.
    INSERT INTO raster_table(name, rast) VALUES ('oss_file', ST_ImportFrom('chunk_table', 'oss://ak:as@bucket/data/beijing.tif'));