Open md-redwan-hossain opened 1 year ago
The hstore (Official Reference) data type is used for storing key-value pairs in a single value. We can add value like the following:
hstore
'"paperback" => "243", "publisher" => "postgresqltutorial.com", "language" => "English"'
Json can be used, but nested data can be passed in this case. hstore enforces key-value pairs without nested data and better query support.
also interested in this.
JANHMS
commented
5 days ago JANHMS
commented
5 days ago
The
hstore(Official Reference) data type is used for storing key-value pairs in a single value. We can add value like the following:'"paperback" => "243", "publisher" => "postgresqltutorial.com", "language" => "English"'Json can be used, but nested data can be passed in this case. hstore enforces key-value pairs without nested data and better query support.