Configures the logon information that is used to access a raster object stored in Alibaba Cloud Object Storage Service (OSS).
Prerequisites
The raster object is stored in OSS.
Syntax
raster ST_SetAccessKey(raster raster_obj, text id, text key, bool valid default true)Parameters
| Parameter | Description |
|---|---|
| raster_obj | The name of the raster object. |
| id | The AccessKey ID that is used to log on to OSS. If you set this parameter to NULL, the previous AccessKey ID is used. |
| key | The AccessKey secret that is used to log on to OSS. If you set this parameter to NULL, the previous AccessKey secret is used. |
| valid | Specifies whether to verify the validity of the logon information. |
Examples
UPDATE raster_table
SET rast = ST_SetAccessKey(rast, 'OSS_ACCESSKEY_ID', 'OSS_ACCESSKEY_SECRET');
SELECT ST_AKId(rast) from raster_table;
st_akid
------------------
OSS_ACCESSKEY_ID