A hash store, also known as a key-value store, or associative array, is a famous data structure in modern programming languages, such as Java, Python, and Node.js. Also, there are dedicated database frameworks to handle this kind of data, such as the Redis database.
PostgreSQL has had a supported hash store, hstore, since PostgreSQL version 9.0. The hstore extension allows developers to leverage the best of both worlds. It increases the developer's agility without sacrificing the powerful features of PostgreSQL. Also, hstore allows the developer to model semi-structured data and sparse arrays in a relational model.
To create the hstore, you simply need to execute the following command as a superuser:
CREATE EXTENSION hstore;
The textual representation of hstore includes a zero or higher key=> value pair, followed by a comma. An example of...