3 ms·I use the JSONP column type in Postgres for data that is structured but user-supplied.by fastball 6y agoI use the JSONP column type in Postgres for data that is structured but user-supplied.jklein11 6y agoThe user is supplying json?fastball 6y agoThere is a key-value interface so not directly.jklein11 6y agoWhy not store this data into a relational database?fastball 6y agoBecause values can be different types (string, int, boolean).jklein11 6y agoCan't you store them all as varchar? You could even have a type column if you wanted to enforce the types in some way at the application level.deleted 6y ago[deleted]