Imports a GLB file into a database.
Syntax
Syntax 1 — Import from a URL:
boolean ST_ImportGLB(text table_name, text url, text id, text options default '{}');Syntax 2 — Import from binary content:
boolean ST_ImportGLB(text table_name, bytea content, text id, text options default '{}');Parameters
| Parameter | Description |
|---|---|
table_name | The name of the GLB table and the prefix of the sharded table. |
url | The URL of the GLB file stored in an object storage service, such as an Object Storage Service (OSS) bucket. For more information, see Object storage paths. |
content | The binary representation of the GLB file. Use this parameter as an alternative to url. |
id | The ID of the GLB file. |
options | The import options. Default value: '{}'. Valid values: schema, flip_y_z, split_meshgeom, split_texture, sfmesh_column, gltf_id_column. |
Usage notes
ST_ImportGLB works the same way as ST_ImportGLTF. The options parameter has the same meaning in both functions.
Examples
Import a GLB file from an OSS bucket:
SELECT ST_ImportGLB('test_glb', 'OSS://<ak>:<ak_secret>@oss-cn-beijing-internal.aliyuncs.com/mybucket/path_to_glb.glb', 'my_glb');
---------
t