Languages
[Edit]
EN

PostgreSQL - Create table with JSON field

0 points
Created by:
Haris65
536

In this article, we would like to show you how to create table with JSON field in PostgreSQL.

Quick solution:

CREATE TABLE "table_name" (
	"column_name" JSON
);

Practical example

In this example, we create objects table with id and json column which will be JSON type.

Query:

CREATE TABLE "objects" (
	"id" SERIAL PRIMARY KEY,
	"json" JSON
);

after we insert some values, we get the following result:

PostgreSQL - create table with JSON field result
PostgreSQL - create table with JSON field result

Note:

Go to this article to see how to insert JSON type values to the table.

Related posts

Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.

PostgreSQL - problems

PostgreSQL - Create table with JSON field
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join