node.js - PostgreSQL "column "foo" does not exist" where foo is the value

Question

I'm trying to perform an Update query on a Postgres db from Node, and I'm running into this weird issue:

'UPDATE salesforce.Guest__c SET currently_at_property__c = "foo" WHERE rewards_id ='+rewardsId,

I'm trying to set the currently_at_property__c equal to the value "foo" but for some reason I'm getting this error:

error: "column "foo" does not exist"

I don't know why this is happening, since foo is the value, NOT the column.

Answer 1

Correct with the right quote:

    'UPDATE salesforce.Guest__c SET currently_at_property__c = 'foo' WHERE rewards_id ='+rewardsId,