1
2DROP TABLE IF EXISTS qgis_test.json;
3
4CREATE TABLE qgis_test.json
5(
6 pk SERIAL NOT NULL PRIMARY KEY,
7 jvalue json,
8 jbvalue jsonb
9);
10
11INSERT INTO qgis_test.json(jvalue, jbvalue)
12 VALUES
13 ('[1,2,3]', '[4,5,6]'),
14 ('{"a":1,"b":2}', '{"c":4,"d":5}');
15