2 ms·
Would you explain a little more? I'm intrigued. Are you saying SQL relations between fields inside JSONB columns between tables? A field in the JSONB column has
by c17r 6y ago
Would you explain a little more? I'm intrigued. Are you saying SQL relations between fields inside JSONB columns between tables? A field in the JSONB column has foreign key to another table? And you can do a join?
- tarkin2 6y agoYou can do both. You can make relations between jsonb fields. Or, as I do: have a jsonb blob in one column, and a normal sql field in another, and do the sql joins with that. So I have some data fields as sql columns, and some as jsonb properties.