JSONB in PostgreSQL

💻 Tech

In PostgreSQL, if the column is of type jsonb, you can use the ->> operator to get the value of a key. For example:

SELECT * FROM users WHERE data->>'id' = '123';