pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Option in preferences to hide table partitions DDL in SQL tab

Open kattunga opened this issue 1 year ago • 1 comments

I need a preference option to not generate DDL from table partitions in SQL tab.

I have a database where each table has hundreds of partitions. When I select a table and SQL tab to view DDL, it takes a long time to generate it because it generates DDL for each partition.

In preferences I disabled "Partitions" in "Browser" -> "Nodes", this hide partitions from the tree, but DDL is still generated.

kattunga avatar Apr 15 '24 21:04 kattunga

we can add one preference to hide DDL SQL if the node is hidden from the browser tree. by default, it will be a false.

RohitBhati8269 avatar Aug 30 '24 11:08 RohitBhati8269