Feature #2022
closed
Additional database export option (dump)
Added by Moritz Großfurtner 12 months ago.
Updated 9 months ago.
Category:
Data import/export
Description
As the default SQL export causes issues in Windows due to different line endings, an easy option for a database export would be appreciated.
Update
An additional export option (dump) was added which is using the -Fc parameters of the pg_dump command.
- Category set to Data import/export
- Status changed from New to Assigned
- Target version set to 7.16.0
Good idea, maybe I look into it with Bernhard together.
- Description updated (diff)
- Description updated (diff)
- Status changed from Assigned to In Progress
Good idea. I see 3 different option to implement it in the UI:
- Check which OS the user uses and export for this OS (worst option)
- Make two export buttons (posix and win)
- Include both versions in 7z file
OR we go away from plain text export to custom -Fc which can be restored with pg_restore.
Going away from plain text might be a good idea but also sounds quite time consuming so I'm not sure if that's the way to go at this moment.
Personally I like the idea of two buttons so that users can choose what they get.
In the feature branch, you have the possibility to create plain or custom SQL format.
To do:
- Description updated (diff)
- Status changed from In Progress to Closed
- Subject changed from Add export option for windows compatible database dump to Additional database export option (dump)
- Description updated (diff)
Thanks for adding the new export function. I took the liberty to rename some params/filenames to reflect the file type but works great otherwise.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by