ST_AKId syntax, parameters, and examples-ApsaraDB RDS(RDS)-阿里云帮助中心

Returns the AccessKey ID used to access a raster object stored in Alibaba Cloud Object Storage Service (OSS).

An AccessKey ID is the identifier component of an AccessKey pair — similar to a username — and is used to authenticate access to OSS. Call this function to inspect which AccessKey ID is associated with a given raster object, for example, before rotating or updating credentials in bulk.

Prerequisites

The raster object must be stored in OSS.

Syntax

text ST_AKId(raster raster_obj)

Return type: text

Parameters

Parameter	Description
`raster_obj`	The raster object to query.

Example

SELECT ST_AKId(rast) from raster_table;

Expected output:

     st_akid
------------------
 OSS_ACCESSKEY_ID

What's next

To update the AccessKey ID for multiple raster objects at a time, use the companion function for bulk AccessKey ID modification.