Six Stars

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

    "
    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.
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

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

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

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

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