[PostgreSql] JSON type 컬럼 Query 방법

공식 문서 참조 : https://www.postgresql.org/docs/9.3/functions-json.html OperatorRight Operand TypeDescriptionExample -> int Get JSON array element '[1,2,3]'::json->2 -> text Get JSON object field '{"a":1,"b":2}'::json->'b' ->> int Get JSON array element as text '[1,2,3]'::json->>2 ->> text Get JSON object field as text '{"a":1,"b":2}'::json->>'b' #> array of text Get JSON object at specified path '{"..