GBASE8s大对象sql语句使用

create table test(id int,b1 text,b2 byte);
vi data.txt
1|1124tweg33|10101010101af|
2|1124tweg33|101011100101af|
3|1124tweg33|101111010101af|
load from './data.txt' delimiter "|" insert into test;

----创建表
drop table if exists tb_struc;
create table tb_struc(
id int,bid bigint, did double precision,nid numeric,
flag boolean,dt date, time_str timestamp, chr char(50),str varchar(50),str2 varchar2(50),bb blob,cb clob);
----插入数据
insert into tb_struc values(1,120000000000,1.23,1.23,1,today, sysdate, 'test str','test str','test str2',filetoblob('1.txt','client'),filetoclob('2.txt','client'));