Tools showing table partitions as tables in listings of tables - Mailing list pgsql-general

From Niels Jespersen
Subject Tools showing table partitions as tables in listings of tables
Date
Msg-id 41f3454665a940399ef246aa96ad0380@dst.dk
Whole thread Raw
Responses Re: Tools showing table partitions as tables in listings of tables
List pgsql-general

Hello all

 

We are very happy with the ongoing work on partitioning i Postgres 11+. We use it in a number of cases.

 

A small irritation point is that some tools decide that partitions under a table are to be shown in a list of tables, sometimes drowning the main table in a sea of partitions.

 

PgAdmin shows partitions below the main table, Datagrip also. Other tools do not. The ones that I have heard about is the SAS System and Enterprise Architect, both connecting through ODBC. I am aware that the issue is really that these tools and/or the ODBC Driver issues queries against the catalog and these queries are naive in respect to table partitions.

 

Any ideas for working around this? Naming partitions in a special manner, something else. It's not the end of the world, but quite irritating for some users.

 

Regards

 

Niels Jespersen

 

 

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Tools showing table partitions as tables in listings of tables