You can use this function to import the data of a trajectory object from Object Storage Service (OSS) to the PolarDB O Edition database that is used to store the trajectory data.

Syntax

trajectory ST_importFrom(trajectory traj);

Parameters

Parameter Description
traj The trajectory object.

Description

This function performs operations that are the reverse of the operations performed by the ST_ExportTo function. If the data of the specified trajectory object is stored in a PolarDB O Edition database table, this function returns the trajectory data. If the trajectory data is stored in a file in OSS, this function imports the trajectory data into the PolarDB O Edition database that is used to store the trajectory data. You can use this function and the Update command to change the data storage location for the specified trajectory object from OSS to the PolarDB O Edition database that is used to store the trajectory data.

This function does not change the OSS file that stores the trajectory data.

Examples

update trajs
set traj = ST_ImportFrom(traj);
UPDATE 4