插入JSON列postgres [重复]

Question

This question already has an answer here:

• Inserting an entry to JSON column in postgres 1 answer

I have a JSON entry like this, which I need to enter into a column (called values)

["Price Descending","Price Ascending","Name Ascending","Date Descending"]

How can I enter this into a json column , what I am trying is this

 $this->db->query("
       INSERT INTO tag_sets (type, value) VALUES
            ('sorting_options', " 
            'Price Descending', 'Price Ascending', 'Name Ascending', 
            'Date Descending'";
      ");

This gives me an error, what is the correct way to insert into a json column?

</div>

Answer 1

Try this

$json = addslashes('"sorting_options",  "Price Descending", "Price Ascending", "Name Ascending", "Date Descending"');

$this->db->query("INSERT INTO tag_sets (type, value) VALUES ('sorting_options', '{$json}')");