JSON - Java Script Object Notation , Postgresql support JSON Data type since 9.2 version. There are some predefined function and operators to access the JSON data. The
-> operator returns the key of JSON column. The
->> operator returns the value of JSON Column.
Creating a pure JSON table
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0