ST_DeleteGTF-PolarDB(PolarDB)-阿里云帮助中心

Deletes all trajectory data files (.gtf) from a specified Object Storage Service (OSS) folder.

Syntax

void ST_DeleteGTF(text directory);

Parameter	Description
`directory`	The OSS folder that contains the trajectory data files. Only OSS folders are supported. Use the following format: `'OSS://<AccessKey ID>:<AccessKey secret>@<Endpoint>/<Bucket>/<Directory>'`

ST_DeleteGTF removes all .gtf files stored in the specified OSS folder. The function returns no value.

SELECT ST_deleteGtf('OSS_PATH');

Replace OSS_PATH with the full OSS connection string in the format 'OSS://<AccessKey ID>:<AccessKey secret>@<Endpoint>/<Bucket>/<Directory>'.