A hash store, key value store, or associative array is a famous data structure among modern programing 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 supported hash store—
hstore—since the PostgreSQL version 9.0. The
hstore extension allows developers to leverage the best in different worlds. It increases the developer's agility without sacrificing the powerful features of PostgreSQL. Also,
hstore allows the developer to model semistructured data and sparse arrays in a relational model.
To create the
hstore, one simply needs to execute the following command:
CREATE EXTENSION hstore;
The textual representation of
hstore includes ...