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

[Anonymous]

    "
    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.

[Anonymous · Accepted solution]

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