pgadmin4
pgadmin4 copied to clipboard
Support restore of plain format SQL dumps
Describe the solution you'd like
Support restore of plain format SQL dumps.
The Restore tool should examine the candidate file when selected in the UI, and figure out if it's a plain SQL dump instead of custom/tar/directory.
If the file is a plain SQL file, it should disable options in the UI that are not relevent, and perform the restore using psql instead of pg_restore.