hstore (TP013)

Automatic fix is available.

What it does

Checks for usage of hstore.

Why not?

Hstore is essentially a key/value store directly in Postgres. With hstore you are a little more limited in terms of the datatypes you have: you essentially just get strings. You also don't get any nesting; in short it's a flat key/value datatype.

When should you?

Hstore can work fine for text based key-value lookups, but in general JSONB can still work great here.

Use instead:

jsonb.