Export Data: offer option to save to SQL script instead of CSV + add "dump table" feature to menù

Open pms967 opened this issue 9 months ago • 1 comments

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).

Mar 21 '25 12:03 pms967

Related to https://github.com/pgadmin-org/pgadmin4/issues/3205

Mar 28 '25 11:03 akshay-joshi