Hello, I am trying to change the address of a party using the database cursor, below is the SQL statement but its not working.
cursor.execute('UPDATE party_address '
'SET country = 111, '
'street = "pen" '
'WHERE party = 111')
#below is the error message i keep receiving
res = self.cursor.execute(sql)
psycopg2.ProgrammingError: column "pen" does not exist
LINE 1: UPDATE party_address SET country = 111, street = "pen" WHERE...
