In this article, we would like to show you how to create table with
JSON field in PostgreSQL.
CREATE TABLE "table_name" ( "column_name" JSON );
In this example, we create
objects table with
json column which will be
CREATE TABLE "objects" ( "id" SERIAL PRIMARY KEY, "json" JSON );
after we insert some values, we get the following result:
Go to this article to see how to insert
JSONtype values to the table.