pgadmin-org / pgadmin-org/pgadmin4
Export Data: offer option to save to SQL script instead of CSV + add "dump table" feature to menù
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
When exporting a query result data (or a table content) using the button or selecting "Import/Export Data" from the menù, it would be nice (and useful) to have the possibility to save the data as an SQL script (i.e. like a pg_dump of the result table) instead of the (default, and currently only available) CSV format.
It would also be nice and useful to have a menù entry to dump (to an SQL script) the selected DB table (only), with option to get data only, schema only or complete dump, and with various methods (copy, inserts, inserts with columns names, like with pg_dump).
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 existing query-result or table-content export button and the “Import/Export Data” menu entry described in the issue. Clarify the scope for SQL-script export and the separate selected-table dump options, including data-only, schema-only, complete, copy, and insert variants. Done should include an agreed implementation and working export paths for the requested modes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100