0

I'm using pg_partman to partition three of my tables and and ended up with a large number of child tables.

Some users find it difficult to navigate whit their database tool (DBeaver or SQuirreL) with this increasing number of tables showing up.

Is there a way to "hide" these table from a user without changing their access rights to them ?

Mohamed BOUAKKAZ
  • 45
  • 2
  • 10

2 Answers2

0

You cannot hide the partitions, but you could put them in a different schema than the partitioned table. Then they are “hidden” if you only look at the schema with the partitioned table.

Laurenz Albe
  • 209,280
  • 17
  • 206
  • 263
0

bump into same question, and didn't found a perfect solution. My work around here is to filter out tables with name %prt%

Roxxette
  • 16
  • 2