topic [resolved] org.postgresql.util.PSQLException:Error: syntax error at or near "." in Talend Studio

[resolved] org.postgresql.util.PSQLException:Error: syntax error at or near "."

Anonymous — Tue, 10 Jan 2017 23:25:06 GMT

"
SELECT
'customer'.'name',
'customer'.'countryOfResidence'
FROM 'customer'
WHERE 'customer'.'countryOfResidence' = 'USA'
"
I am querying a table in postgreSQL through Talend and cannot seem to perceive where the error is. Can someone help out please.

Re: [resolved] org.postgresql.util.PSQLException:Error: syntax error at or near "."

Anonymous — Tue, 10 Jan 2017 23:28:12 GMT

Got it Talend takes table names as double quotes:
SELECT
"customer"."name",
"customer"."countryOfResidence"
FROM "customer"
WHERE "customer"."countryOfResidence" = 'USA'