Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

250
Views
update query in postgrel RDS on aws

“42703” or “Column does not exist” Understanding the issue

I have trying to update the table RDS specific to postgrel with by inserting new attribute in class object.
The data would something like this after inserting or updating :

"class" : { "isPresent" : false }

Details :
Database : postgrel
Table name : student
Attributes for table :  student_id, class
"class" attribute is of object type

This query works on my machine

update "student" set "class" = jsonb_set("class"::jsonb, '{isPresent}','false', true) WHERE "student_id" =1

When I'm trying to do the same query, on aws postgrel it does not work and throws an error query :

{
  "query": "update student set class = jsonb_set('\"student.class\"'::jsonb, '{isPresent}','false', true) WHERE '\"student.student_id\"' = 1"                                  
}

Error :

"column \"class\" of relation \"student\" does not exist"

When tried this, gives syntax erro :

{
   "query": "update '\"student\"' set '\"class\"' = jsonb_set('\"student.class\"'::jsonb, '{isPresent}','false', true) WHERE '\"student.student_id\"' = 1"                                  
    }

I think the issue is syntax error : postgrel quotes syntax but have no idea how can I use double quotes under doble quotes

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!