pgadmin-org / pgadmin-org/pgadmin4
Add JSON format support for "Export data" operation
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
Describe the solution you'd like
In the "Import/Export data" operation for a table, there're 3 formats available: binary, csv, and text. (I am using v.6.17 but searching thru issues I could not find anything relevant either, so please close a Duplicate if already implemented in later version)
I would like to have "json" option available too
Describe alternatives you've considered
I guess, there're tools out there converting csv to JSON; should not be too difficult
Additional context
I'm used to export data as JSON in some SQL clients, like dBeaver or IntelliJ DataGrip; unfortunately, for some DBs I can not use those and can only use pgAdmin; so it would be great to have this feature here as well
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 by locating the table-level "Import/Export data" operation and tracing how its existing binary, CSV, and text formats are selected and generated. The work is done when JSON is available as an export option and produces the expected table data in JSON format alongside the existing choices.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100