Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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