插入数据
最近更新时间: 2025-02-18 16:02:00
postgres=# insert into t_json values(1,'{"col1":1,"col2":"TDSQL PG"}');
INSERT 0 1
postgres=# insert into t_json values(2,'{"col1":1,"col2":"TDSQL PG","col3":"pgxz"}');
INSERT 0 1
postgres=# select * from t_json;
id | f_json
----+-----------------------------------------
1 | {"col1":1,"col2":"TDSQL PG"}
2 | {"col1":1,"col2":"TDSQL PG","col3":"pgxz"}
(2 rows)