DBeaver does not show all tables in a Schema

Started by Shaozhong SHIover 4 years ago7 messagesgeneral
Jump to latest
#1Shaozhong SHI
shishaozhong@gmail.com

I used a DBeaver to connect to postgres but it does not show all tables in
a schema.

Can anyone shed light on this?

Regards,

David

#2Ron
ronljohnsonjr@gmail.com
In reply to: Shaozhong SHI (#1)
Re: DBeaver does not show all tables in a Schema

On 10/29/21 5:46 AM, Shaozhong SHI wrote:

I used a DBeaver to connect to postgres but it does not show all tables in
a schema.

Can anyone shed light on this?

Permissions?

--
Angular momentum makes the world go 'round.

#3negora
public@negora.com
In reply to: Shaozhong SHI (#1)
Re: DBeaver does not show all tables in a Schema

Are you sure that you're not applying a filter in the "Database
Navigator" panel of DBeaver?

Sometimes, it occurs to me that I apply a filter for certain database, I
forget to remove it, then open another database, and some or all tables
do not appear in the navigator.

Show quoted text

On 29/10/2021 12:46, Shaozhong SHI wrote:

I used a DBeaver to connect to postgres but it does not show all
tables in a schema.

Can anyone shed light on this?

Regards,

David

#4Shaozhong SHI
shishaozhong@gmail.com
In reply to: negora (#3)
Re: DBeaver does not show all tables in a Schema

It is a new installation with all permissions. Nothing has done to it.

Regards,

David

On Fri, 29 Oct 2021 at 14:14, negora <public@negora.com> wrote:

Show quoted text

Are you sure that you're not applying a filter in the "Database
Navigator" panel of DBeaver?

Sometimes, it occurs to me that I apply a filter for certain database, I
forget to remove it, then open another database, and some or all tables
do not appear in the navigator.

On 29/10/2021 12:46, Shaozhong SHI wrote:

I used a DBeaver to connect to postgres but it does not show all
tables in a schema.

Can anyone shed light on this?

Regards,

David

#5Ryan Booz
ryan@timescale.com
In reply to: Shaozhong SHI (#4)
Re: DBeaver does not show all tables in a Schema

In a recent update (not sure when), the default for DBeaver seems to have
changed so that the navigator view is set to "simple", rather than
"advanced" which shows all objects.

Right-click the server -> edit connection -> Select "General" -> verify
"Navigator View"

On Fri, Oct 29, 2021 at 9:48 AM Shaozhong SHI <shishaozhong@gmail.com>
wrote:

Show quoted text

It is a new installation with all permissions. Nothing has done to it.

Regards,

David

On Fri, 29 Oct 2021 at 14:14, negora <public@negora.com> wrote:

Are you sure that you're not applying a filter in the "Database
Navigator" panel of DBeaver?

Sometimes, it occurs to me that I apply a filter for certain database, I
forget to remove it, then open another database, and some or all tables
do not appear in the navigator.

On 29/10/2021 12:46, Shaozhong SHI wrote:

I used a DBeaver to connect to postgres but it does not show all
tables in a schema.

Can anyone shed light on this?

Regards,

David

#6Shaozhong SHI
shishaozhong@gmail.com
In reply to: Ryan Booz (#5)
Re: DBeaver does not show all tables in a Schema

On Fri, 29 Oct 2021 at 14:53, Ryan Booz <ryan@timescale.com> wrote:

In a recent update (not sure when), the default for DBeaver seems to have
changed so that the navigator view is set to "simple", rather than
"advanced" which shows all objects.

Right-click the server -> edit connection -> Select "General" -> verify
"Navigator View"

I am afraid that this did not make a difference.

Regards,

David

#7Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Shaozhong SHI (#1)
Re: DBeaver does not show all tables in a Schema

On 10/29/21 03:46, Shaozhong SHI wrote:

I used a DBeaver to connect to postgres but it does not show all tables
in a schema.

Can anyone shed light on this?

Not without:

1) Postgres version

2) DBeaver version

3) JDBC version

4) Example of what you expect to see vs what you are seeing
In other words how do you know you are not seeing all tables?

5) Verification that you are connecting to correct database.

Regards,

David

--
Adrian Klaver
adrian.klaver@aklaver.com