search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.42k stars 633 forks source link

Option in preferences to hide table partitions DDL in SQL tab #7379

Open kattunga opened 5 months ago

kattunga commented 5 months ago

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.

RohitBhati8269 commented 2 weeks ago

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.