select id, roles from master.users
where roles::jsonb ? 'admin'-> 같은 걸로 응용가능하다
'database' 카테고리의 다른 글
| [MongoDB] insert (0) | 2019.08.02 |
|---|---|
| MongoDb Query (0) | 2019.08.02 |
| if exist drop index and create index in MYSQL (0) | 2019.05.18 |
postgresql] json array include string
2021. 2. 23. 00:42