Problems using Postgres ELT

Anonymous — Fri, 01 Jun 2012 19:46:38 GMT

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

Re: Problems using Postgres ELT

Anonymous — Mon, 04 Jun 2012 06:24:25 GMT

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

topic Problems using Postgres ELT in Talend Studio

Problems using Postgres ELT

Re: Problems using Postgres ELT