title: How to instruct pentaho-kettle to keep uppercase table names in PostgreSQL?
body: <p>Pentaho-Kettle is lowercasing the table names included in a select-based sql query derived from an XML file I cannot manipulate. As I have to execute this sql query against a PostgreSQL database which contains uppercased table names, Pentaho-Kettle logs errors at the time of executing the corresponding job.</p>
  
  <p>The select-based sql queries I have to deal with are in this way:</p>
  
  <pre><code>SELECT tblBAS.*, tblLTFU.FIELD1 FROM tblBAS INNER JOIN ... ON ... WHERE ...
  </code></pre>
  
  <p>And the PostgreSQL database I have to work with does contain a couple of tables named <code>tblBAS</code> and <code>tblLTFU</code>.</p>
  
  <p>I know that if I manually modify the query to quote table names, Pentaho-kettle executes the query properly, but I cannot manipulate the whole set of queries within the XML file, as said before.</p>
  
  <p>In the 'Database Connection window > Advanced' section of the <code>Table Input</code> step where I'm attempting to execute the query, I've checked 'Quote all in database' option but with no success. It seems that the PostgreSQL driver of Pentaho-Kettle automatically lowercases table names and fields of the queries.</p>
  
  <p>Does any Pentaho-Kettle expert knows a way of instructing Pentaho (or Pentaho PostgreSQL driver) to keep the names of table names and fields of a sql query in a mixed of upper-lowercase letters? Any workaround will be appreciated too.</p>