How to only get a key from a key pair?

Hi! This is for Redshift and a JSON question.

I was wondering how to get only the sub-key value from a key pair value. I am trying to pull the value KITCHEN from the example below. I apologize if my terms are used incorrectly!

Example: {“house” {“kitchen”:”fridge”

submitted by /u/dtla99
[link] [comments]


Go to Source of this post
Author Of this post: /u/dtla99
Title Of post: How to only get a key from a key pair?
Author Link: {authorlink}