Am 2013-08-20 01:43, schrieb Demoy Blake:
> 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...
>
postgresql expects single quotes for string-literals, double quotes for
column/table names.
