ST_AKId function to query the AccessKey ID of an OSS raster object - PolarDB

Returns the AccessKey ID used to access a raster object stored in Object Storage Service (OSS). This function can be used with the function that is used to modify multiple AccessKey IDs at a time.

Prerequisites

The raster object must be stored in OSS.

Syntax

text ST_AKId(raster raster_obj)

Parameters

Parameter	Description
`raster_obj`	The name of the raster object.

Examples

Query the AccessKey ID of a raster object:

SELECT ST_AKId(rast) FROM raster_table;

Expected output:

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