Retrieve shema of materialized view on postgresql DB

One Star

Retrieve shema of materialized view on postgresql DB

Hi,
I want to push instances of postgre materialized view in a mysql table.
So I create two DB connections, and I retrieve schema of postgre and mysql.
But I can't see my materialized view, I can only see the table, it's normal ?
I have select Table, View and Synonym in select types.
Thanks in advance
Pierre
Seventeen Stars

Re: Retrieve shema of materialized view on postgresql DB

This should not happened. A materialized view is actually a table with a special environment and should be visible as table. Are you sure you have the correct right to read and see the materialized view?
One Star

Re: Retrieve shema of materialized view on postgresql DB

Materialized view are available only with postgres 9.3 but Talend seem don't have postgres connector 9.3
Seventeen Stars

Re: Retrieve shema of materialized view on postgresql DB

hi,
you can "update Postgres components" to use v9.x
/* replace version into  xml file of the component : tPostgresqlConnection_java */
<CODEGENERATION> -<IMPORTS> <IMPORT NAME="Driver-Postgres" REQUIRED="true" MODULE="postgresql-8.3-603.jdbc3.jar"/> </IMPORTS> </CODEGENERATION>

or create a new one and keep native Talend component unchanged (a better solution i Think).
hope it helps
regards
laurent