All Products
Search
Document Center

:ST_ImportGLB

Last Updated:Jul 27, 2023

This topic describes the ST_ImportGLB function. This function imports a GLB file into a database.

Syntax

  • Syntax 1

    boolean ST_ImportGLB(text table_name, text url,  text id, text options default '{}');
  • Syntax 2

    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

If the GLB file is stored in an object storage service, such as an Object Storage Service (OSS) bucket, use this parameter. For more information, see Object storage paths.

id

The ID of the GLB file.

content

If you want to import the GLB file by using its binary representation, use this parameter. Alternatively, you can use the url parameter.

options

The options for the import. Valid values:

  • schema

  • flip_y_z

  • split_meshgeom

  • split_texture

  • sfmesh_column

  • gltf_id_column

Description

This function imports a GLB file into a database.

The ST_ImportGLB function is used in the same way as the ST_ImportGLTF function. In addition, the options parameter for the functions have the same meaning.

Examples

SELECT ST_ImportGLB('test_glb', 'OSS://<ak>:<ak_secret>@oss-cn-beijing-internal.aliyuncs.com/mybucket/path_to_glb.glb', 'my_glb');

---------
t