准备
create table test(
id bigserial primary key not null,
doc jsonb,
ar jsonb default '[]'::jsonb,
create_time TIMESTAMP not null default LOCALTIMESTAMP
);
--针对jsonb 插入部分值
insert into test values(1,'{"nickname": "gs", "tags":{"name":"language","detail":["python", "golang", "db"]}}','[1,3]',now());
insert into test values(2,'{"num":2,"nickname": "gs", "tags":{"name":"computer","detail":["lenvo", "hp"]}}','[1,2,4]',now()