pgadmin-org / pgadmin-org/pgadmin4
Option in preferences to hide table partitions DDL in SQL tab
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start from the Preferences > Browser > Nodes setting for Partitions and the table SQL tab that generates DDL. Trace how the existing preference is read and how partition DDL is included, then identify the relevant tests or add coverage for a new preference. Done means the SQL tab can omit partition DDL while retaining the current behavior by default.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100