GetTableData processor doesnt work with Postgres case sensitive tables/columns

Description

The GetTableData processor doesnt create the correct SQL select statement when working off a database that is case sensitive column names

The code in GetTableDataSupport.java, line 78 generates the SELECT for the query.
The selectStatement() call does a simple join of the columns by a comma. Postgres requires the column names to be quoted for case sensitivity:
Example:

Instead of SELECT d.NAME, d.TBL_NAME FROM ...
It needs to be: SELECT d."NAME", d."TBL_NAME" ...

  • Detect if using Postgres or not

  • Quote the select accordingly when getting the select statement

Environment

None
Done

Assignee

Jagrut Sharma

Reporter

Scott Reisdorf

Labels

None

Reviewer

None

Story point estimate

None

Sprint

None

Fix versions

Priority

Medium