Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Postgres Tables not showing under "Create Select Statement"

When I use an ODBC connection to my postgres DB, it doesn't seem to display the database tables or table fields on the "Create Select Statement" page.

Is there a limitation on the number of tables it can show ?

Very bizzare

3 Replies

Re: Postgres Tables not showing under "Create Select Statement"

Does the account with which you create the DB CONNECTion have enough rights to access any tables in the current DB?

Not applicable

Re: Postgres Tables not showing under "Create Select Statement"

Thanks for the reply Peter

Yip, the user def has the correct permissions.

If I use MSQuery in Excel I can see the tables there ?

Capture2.JPG

Not applicable

Re: Postgres Tables not showing under "Create Select Statement"

Any ideas anyone ?