How to store write options in PostgreSql?

Question

PostgreSQL

The idea is, it would be cool if I had a hash type in which I could put key=>value values. I will also need to filter records by these values. Prompt how it is correct to organize a DB?

Answer 1

It would be cool if you created a table with two fields and stored your values, you can even filter - I give a tooth 100% works.

Answer 2

You can use the jsonb type. If there are many keys, then you can impose gin index.
SM:
- one
- two