Create tables and simple operations with the jsonb datatype

[rkarthik007]

• Create a table with the jsonb column to hold flexible schema documents:

CREATE TABLE books ( id int PRIMARY KEY, data jsonb );

• Insert data into it:

INSERT INTO books (id, data) VALUES (1, '{ "name": "ABC", "author": "John Smith" }');

• Query the data:

SELECT * from books;
SELECT * from books WHERE id=1;

[pritamdamania87]

be2d598