Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
AleksandrS
Contributor
Contributor

Qlik connect to a postgres fdw

Hello.

I have Postgres foreign data wrapper. 

I installed Qlick sense Desktop.

Qlik connected to postgres complete, but postgres_fdw qlick not view data.

I see scheme, but no data in tables.

Maybe there is a special odbс driver?

1 Reply
MaWi
Contributor II
Contributor II

I run in the same problem.

Finally i figured out, that only the PostgreSQL table_types "VIEW" and "BASE TABLE" are listed in the Qlik data manager. Foreign Data Wrappers (FDW) are in PostgreSQL internally signed as "FOREIGN". Thats seem to be the reason why they are not listed.

But if you have set the correct access rights, then u can use them, although you dont see them: just try to make a simple SQL SELECT * FROM {my_fwd_table} and u will get all the data out of your FDW.

 

Regards

MaWi