This topic describes how to configure the ST_ImportFrom function. You can use the ST_ImportFrom function to transfer an Object Storage Service (OSS) file to a raster object in Apsara PolarDB.
Syntax
raster ST_ImportFrom(cstring chunkTableName, cstring url);Parameters
| Parameter | Description |
|---|---|
| chunkTableName | The name of the chunk table. The name must comply with the table naming conventions of Apsara PolarDB. |
| url | The URL of the external OSS object. For more information, see the description of the url parameter in ST_CreateRast. |
Description
The ST_ImportFrom function creates a raster object and imports an external OSS object into the raster object.
The following table lists the supported raster formats.
| Format | Full name |
| BMP | Microsoft Windows Device Independent Bitmap(.bmp) |
| EHdr | ESRI .hdr Labelled |
| ENVI | ENVI .hdr Labelled Raster |
| GTiff | TIFF/BigTIFF/GeoTIFF(.tif) |
| HFA | Erdas Imagine .img |
| RST | Idrisi Raster Format |
| INGR | Intergraph Raster Format |
| netCDF | NetCDF: Network Common Data Form |
| AAIGrid | Arc/Info ASCII Grid |
| AIG | Arc/Info Binary Grid |
| GIF | Graphics Interchange Format |
| PNG | Portable Network Graphics |
| JPEG | JPEG JFIF File Format |
Example
Select ST_ImportFrom('chunk_table','OSS://ABCDEFG:1234567890@oss-cn.aliyuncs.com/mybucket/data/4.tif');