How to store parameter values ​​in PostgreSQL?

Question

PostgreSQL

For example, an XML file (YML file), which is used to upload goods to Yandex Market , is best suited to the question . Inside there are parameters for the product offer: product height, weight, and others. So, the values ​​of these parameters are either numbers, or strings, or sets (a string with an enumeration) ... How to store these values ​​in a table if they are involved in the search? For example, if we consider all values ​​as strings, then how to compare numbers in string representation? Tell me where to dig or maybe someone has already solved such problems and will tell you the solution to this problem.

Answer 1

use jsonb

Answer 2

www.postgresql.org/docs/current/static/datatype-xm...