topic Postgres Tables not showing under "Create Select Statement" in QlikView

Postgres Tables not showing under "Create Select Statement"

Fri, 05 Feb 2016 12:36:52 GMT

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

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

Peter_Cammaert — Fri, 05 Feb 2016 17:57:34 GMT

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

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

Sat, 06 Feb 2016 08:25:07 GMT

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 ?

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

Fri, 12 Feb 2016 09:19:27 GMT

Any ideas anyone ?