EN
PostgreSQL - Create table with JSON field
0 points
In this article, we would like to show you how to create table with JSON field in PostgreSQL.
Quick solution:
xxxxxxxxxx1
CREATE TABLE "table_name" (2
"column_name" JSON3
);In this example, we create objects table with id and json column which will be JSON type.
Query:
xxxxxxxxxx1
CREATE TABLE "objects" (2
"id" SERIAL PRIMARY KEY,3
"json" JSON4
);after we insert some values, we get the following result:
Note:
Go to this article to see how to insert
JSONtype values to the table.
