Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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
Author

Any ideas anyone ?