You can translate the question and the replies:

Quoting columns that are keywords or start with digits

I'm trying to run the following query against a virtualized Postgres database via JDBC SELECT "fielding" . "gs" AS "gs" FROM "data_world_gosales" . "fielding" AS "fielding" I get an error Field not found 'fielding.gs' in view 'fielding' . Other fields work, so I'm assuming the issue has to do with 'gs' being a keyword. I get similar errors with fields that begin with numbers SELECT "batting" . "2b" AS "_2b" FROM "data_world_gosales" . "batting" AS "batting". Your documentation indicates that this should work, as I've double-quoted the identifiers. Is there something else I would be doing?
user
24-03-2020 10:47:27 -0400

1 Answer

Hi, I was not able to reproduce the error. Double quotes worked for me and I tried it with different keywords and I was able to retrieve the data. My suggestion is to check whether this field exists in the view specified. Hope it helps!
Denodo Team
25-03-2020 10:41:10 -0400
You must sign in to add an answer. If you do not have an account, you can register here