Problems using Postgres ELT

One Star

Problems using Postgres ELT

Hello,
I'm trying to use Postgres ELT components, but i am getting some errors. The main error is because i have some tables that were created using upper case and others using lower case, for example:
TABLE_TEST and table_test_02.
The problem is that Postgres is case sensitive and when Talend tries to send the query to database, postgres does not recognize the table name. So the solution is use quotes in the table name, for example, instead i use:
select * from TABLE_TEST
I have to use
select * from "TABLE_TEST"
But i cannot put quote manually inside table name in Talend.
Does anyone knows how can i do this? Or anyone has passed for the same problem?
Thanks
Best regards
One Star

Re: Problems using Postgres ELT

Hi
If you create metadata->DB Connection->Postgres, you will find out that the query of tPostgresqlInput is like this.
"SELECT 
\"test\".\"public\".\"DU\".\"newColumn\",
\"test\".\"public\".\"DU\".\"newColumn1\"
FROM \"test\".\"public\".\"DU\""

Add '\' in front of quote.
Regards,
Pedro

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch