Introduction to hstore

The PostgreSQL extension, hstore, implements a data type for storing sets of key/value pairs within a single PostgreSQL value. This can be useful in various scenarios, such as rows with many attributes that are rarely examined or semi-structured data. Keys and values are simply text strings.

We could go so far as to say that hstore is a precursor to JSON support in PostgreSQL, as ...