-
Notifications
You must be signed in to change notification settings - Fork 9
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Export using SQL insert #36
Comments
|
+1 |
1 similar comment
+1 |
|
+1 @jakob you should consider using https://www.bountysource.com/ for crowd funding feature requests like these. |
@astewart-twist: This is not an OS project so I don't think @jakob can use bountysource (maybe other similar platforms exist?) (https://github.com/bountysource/core/wiki/Frequently-Asked-Questions). I hope I'm not going too off-topic but, I would say the best way to support the development is to buy the app or recommending it. Since I bought the app already I'm just gonna recommend it: https://twitter.com/humanfromearth/status/672559977446416385 I encourage you to do the same! |
I also purchased the product and wanted to add that I also would like to see an SQL export feature. There are certain instances where I do not have access to pgdump and therefore the ability to do some from Postico would be great. I would pay extra to have had this feature had I known it was not native in the app. Love the product, just wish it was more complete. |
I have a short question for everyone: would it be useful if I implemented a feature to just export the data as INSERT statements (like the copy special command), rather than creating a full SQL dump like pg_dump does? Exporting just the data would be much easier to implement than creating a full SQL dump. |
For me INSERT statements are more than enough. |
I concur. Nicholas Colyer
|
I also agree INSERTs are enough. I mean definitely much better than nothing! On Sat, Dec 5, 2015 at 2:16 AM, Nicholas Colyer notifications@github.com
|
+1 for this feature. |
+1 for import / export of sql. |
+1 |
+1, really hope this feature can be implemented. |
+1 for import / export of sql. |
+1 |
1 similar comment
+1 |
@xarg I'm sorry to hear you're not happy with the pace of development. I try to prioritise features according to the impact they have versus the amount of effort required. Touch Bar is high impact & low effort, so it was a great first task for Chris, who is just getting started with Postico development. Adding SQL export is a bit more effort, even though most of the parts are already there. Considering how many people support this issue, it was probably a mistake to delay this so long, and I should have started sooner. I'll see what I can do. Currently I'm finalising the graphical index editor (#19) and trying to get the 1.1 update with lots of bug fixes out the door, but that release is blocked by an issue with Core Graphics on macOS 10.10 that I still need to work around. Meanwhile, Chris has started to work on CSV import (#68). |
Thanks for your detailed reply @jakob. I appreciate it. |
+1 |
|
+1 |
2 similar comments
+1 |
+1 |
+1 |
+1 - very disappointed that this feature is not available. I bought Postico, thinking about using an alternative package. Other than that, great tool! |
+1 |
3 similar comments
+1 |
+1 |
+1 |
+1 It is more than 2 years already. |
+1 just want sql inserts, nothing fancy. |
+1 |
3 similar comments
+1 |
+1 |
+1 |
+1 :) |
👍 |
4 similar comments
+1 |
+1 |
+1 |
+1 |
Oh how nice would it be to be able to dump the entire database into a file! |
+1 for sql inserts |
|
+1 |
2 similar comments
+1 |
+1 |
+1 :) That is the last thing preventing me from buying it :) |
+1 |
Since we keep getting requests for this feature, I would like to ask for some feedback.
Background: For us this feature currently doesn't have a high priority, but maybe we are missing some important scenarios how this feature would be useful, so please let us know how you would use this feature! |
Maybe you can take a look at Sequal Pro; there is a Export > As SQL dump option which works good. This makes it more easy to transfer database with a GUI like Postico.
Gr., Jasper
…On 9 Apr 2021, 11:53 +0200, Jakob Egger ***@***.***>, wrote:
Since we keep getting requests for this feature, I would like to ask for some feedback.
1. Do you really want to just export INSERT statements to a file, or do you want full dumps (including CREATE TABLE statements etc)
2. Can you explain how you would use this feature in a few sentences?
3. Is using CSV Export / Import a possible alternative?
Background:
Most people who contact us via email with similar feature requests want a way to create full dumps (like pg_dump creates). These full dumps would contain both CREATE TABLE statements and INSERT statements. Implementing this feature would be a major undertaking and something that we just do not have the capacity for. Also, there's already pg_dump which does exactly what people want, so I don't see a strong argument for adding this feature to Postico. It would be convenient to have it built in, but it wouldn't really allow new workflows that currently aren't possible.
For us this feature currently doesn't have a high priority, but maybe we are missing some important scenarios how this feature would be useful, so please let us know how you would use this feature!
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub, or unsubscribe.
|
Basically I'd want both:
I would use it to:
Also a nice feature, but for me it wouldn't. |
Would be great to be able to export a table using SQL inserts. Right now only CSV seems to be available. Copy Special is great, but works only for the selected rows, not for whole tables.
Or if SQL inserts are hard to implement, perhaps just importing CSV would be nice.
How I do it now:
COPY table FROM 'xxxx.csv' DELIMITER ',' CSV;
The text was updated successfully, but these errors were encountered: