ST_SetAccessKey helper function for Raster-ApsaraDB RDS(RDS)-阿里云帮助中心

Configures the credentials on a raster object for accessing Object Storage Service (OSS).

Prerequisites

The raster object must be stored in OSS.

Syntax

raster ST_SetAccessKey(raster raster_obj, text id, text key, bool valid default true)

Parameters

Parameter	Description
raster_obj	The raster object to configure.
id	The AccessKey ID for logging on to OSS. If set to NULL, the previous AccessKey ID is retained.
key	The AccessKey secret for logging on to OSS. If set to NULL, the previous AccessKey secret is retained.
valid	Specifies whether to verify the logon credentials. Default value: true.

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