Reference: Json Types
CedarDB supports JSON as a flexible format to store embedded documents.
CedarDB has two storage types, json
as a text representation and jsonb
as a binary representation.
Usage Example
create table example (
doc jsonb
);
insert into example
values (jsonb '{"x":1}');
select doc, doc->'x' from example;
doc | ?column?
---------+----------
{"x":1} | 1
(1 row)