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)

For more information on how to work with JSON, take a look at our JSON function reference.