So what you need to do is at least to create a table with a column having as data type JSON, and then insert data into it: =# CREATE TABLE json_tab (data json); CREATE TABLE =# INSERT INTO json_tab VALUES ('{"key":"value","key2":"value2"}'); INSERT 0 1 =# select * from json_tab ; data --------------------------------- {"key":"value","key2":"value2"} (1 row) --