vscode-postgres icon indicating copy to clipboard operation
vscode-postgres copied to clipboard

Published 20 hours ago • verified publisher icon Borvik

Tables not displaying

Open magick93 opened this issue 3 years ago • 3 comments

Hello

I'm only able to see the following - not tables. I've tried refreshing, and re-opening vscode. But these havent helped. When I use psql and \ld I can see them, so its not a user permissions issue.

image

magick93 avatar Jun 21 '21 04:06 magick93

Are you using something like Heroku, or Amazon RedShift? Also what is the extension version and your vscode version?

Borvik avatar Jun 21 '21 10:06 Borvik

Not using Heroku, or Amazon RedShift

The version of the extension is v1.1.18. Vscode version is 1.57,1

magick93 avatar Jun 21 '21 20:06 magick93

While your user may have permission to the tables you want to see (as evidenced by \ld) - your user may not have access to the tables the plugin is using in it's queries for the tables.

There are a few different queries that could be used to gather the tables, depending on the PG version. If you could verify your PG version, I can check on those queries.

Borvik avatar Jun 21 '21 20:06 Borvik