Export using SQL insert #36

xarg · 2015-07-24T07:43:24Z

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:

eightyfive · 2015-08-27T15:40:47Z

~~+1 preventing me from buying the full version~~

adi- · 2015-09-02T09:32:25Z

+1

trapias · 2015-09-22T21:51:48Z

+1

eightyfive · 2015-09-23T03:11:24Z

pg_dump -U username -d databasename > outputfile.sql

astewart-twist · 2015-12-03T21:49:33Z

+1 @jakob you should consider using https://www.bountysource.com/ for crowd funding feature requests like these.

xarg · 2015-12-03T23:41:19Z

@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!

ncolyer · 2015-12-04T18:42:43Z

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.

jakob · 2015-12-04T19:02:15Z

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.

xarg · 2015-12-04T19:12:21Z

For me INSERT statements are more than enough.

ncolyer · 2015-12-04T19:15:56Z

I concur.

Nicholas Colyer

On Dec 4, 2015, at 2:12 PM, Alex Plugaru notifications@github.com wrote:

For me INSERT statements are more than enough.

—
Reply to this email directly or view it on GitHub.

eightyfive · 2015-12-05T02:31:49Z

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
wrote:

I concur.
Nicholas Colyer

On Dec 4, 2015, at 2:12 PM, Alex Plugaru notifications@github.com wrote:

For me INSERT statements are more than enough.

—
Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHub:
#36 (comment)

g3d · 2016-01-16T13:29:44Z

+1 for this feature.
I also purchased the product and wanted to add SQL export feature into it.

jacobbullock · 2016-04-23T23:42:04Z

+1 for import / export of sql.

punkratz312 · 2016-06-02T14:53:28Z

+1

cupnoodle · 2016-09-11T15:10:27Z

+1, really hope this feature can be implemented.

rexzhang · 2016-10-16T04:14:09Z

+1 for import / export of sql.

jbreuer95 · 2017-01-11T11:13:12Z

+1

francoisbruneau · 2017-01-19T09:35:18Z

+1

xarg · 2017-01-20T22:24:59Z

While having MacBook Pro Touchbar support #311 is cool, I'm really disappointed seeing it done while an issue like the current one or more importantly #82 have almost 2 years since are reported and nothing was done about it so far. @jakob can you give us an update on this? What's happening?

jakob · 2017-01-21T11:39:35Z

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

xarg · 2017-01-23T16:45:38Z

Thanks for your detailed reply @jakob. I appreciate it.

atMari · 2017-02-03T00:46:20Z

+1

rensverschuren · 2017-04-11T14:57:39Z

+ 1

billyshena · 2017-05-23T16:02:45Z

+1

schuon · 2017-07-14T10:23:17Z

+1

lloydh · 2017-08-18T14:21:20Z

+1

tobyhinloopen · 2017-08-23T09:30:08Z

+1

cokron · 2017-11-02T16:41:05Z

+1 - very disappointed that this feature is not available. I bought Postico, thinking about using an alternative package. Other than that, great tool!

terehov · 2018-01-03T04:38:40Z

+1

ctoLarsson · 2018-01-03T11:05:06Z

+1

bingimar · 2018-02-05T11:50:39Z

+1

jidesakin · 2018-03-05T13:57:41Z

+1

ghost · 2018-03-06T00:08:57Z

+1 It is more than 2 years already.

thorntonjohn · 2018-03-21T16:22:09Z

+1 just want sql inserts, nothing fancy.

kidbrax · 2018-05-03T17:02:51Z

+1

rouralberto · 2018-07-05T04:57:57Z

+1

pyrat · 2018-08-08T08:11:17Z

+1

jjhesk · 2018-08-17T13:59:27Z

+1

bed42 · 2018-11-02T07:21:25Z

+1 :)

Jaspur · 2019-03-15T09:06:17Z

👍

FedeGens · 2019-04-16T10:37:20Z

+1

pwm · 2019-05-31T09:39:46Z

+1

aazcast · 2019-08-02T17:22:23Z

+1

stevenleeg · 2019-09-06T22:19:50Z

+1

striveforbest · 2019-09-26T18:19:13Z

Oh how nice would it be to be able to dump the entire database into a file!

karam-nus · 2019-10-15T09:05:16Z

+1 for sql inserts

andresilvagomez · 2019-11-07T16:38:50Z

1

leobenkel · 2020-07-30T04:04:28Z

+1

devglrd · 2020-08-16T17:29:18Z

+1

juliofalbo · 2020-09-24T13:52:05Z

+1

barttenbrinke · 2020-10-20T07:23:54Z

+1 :) That is the last thing preventing me from buying it :)

isavita · 2021-04-09T08:59:20Z

+1

jakob · 2021-04-09T09:52:50Z

Since we keep getting requests for this feature, I would like to ask for some feedback.

Do you really want to just export INSERT statements to a file, or do you want full dumps (including CREATE TABLE statements etc)
Can you explain how you would use this feature in a few sentences?
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!

Jaspur · 2021-04-09T09:57:46Z

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.

tobyhinloopen · 2021-04-09T10:05:03Z

Do you really want to just export INSERT statements to a file, or do you want full dumps (including CREATE TABLE statements etc)

Basically I'd want both:

CREATE TABLE + INSERTS (full copy)
only INSERTs (data dump) (--data-only)
only CREATE TABLEs (structure dump) (--schema-only)

Can you explain how you would use this feature in a few sentences?

I would use it to:

copy and sync database schemas and data between databases
import SQL dumps i've received elsewhere
share SQL dumps with other people

Is using CSV Export / Import a possible alternative?

Also a nice feature, but for me it wouldn't.

jakob added the enhancement label Sep 28, 2015

jakob added the maybe-later label Oct 30, 2015

jakob modified the milestone: v1.2 Mar 23, 2017

Export using SQL insert #36

Export using SQL insert #36

Comments

xarg commented Jul 24, 2015

eightyfive commented Aug 27, 2015

adi- commented Sep 2, 2015

trapias commented Sep 22, 2015

eightyfive commented Sep 23, 2015

astewart-twist commented Dec 3, 2015

xarg commented Dec 3, 2015

ncolyer commented Dec 4, 2015

jakob commented Dec 4, 2015

xarg commented Dec 4, 2015

ncolyer commented Dec 4, 2015

eightyfive commented Dec 5, 2015

g3d commented Jan 16, 2016

jacobbullock commented Apr 23, 2016

punkratz312 commented Jun 2, 2016

cupnoodle commented Sep 11, 2016

rexzhang commented Oct 16, 2016

jbreuer95 commented Jan 11, 2017

francoisbruneau commented Jan 19, 2017

xarg commented Jan 20, 2017

jakob commented Jan 21, 2017

xarg commented Jan 23, 2017

atMari commented Feb 3, 2017

rensverschuren commented Apr 11, 2017 • edited Loading

billyshena commented May 23, 2017 • edited Loading

schuon commented Jul 14, 2017

lloydh commented Aug 18, 2017

tobyhinloopen commented Aug 23, 2017

cokron commented Nov 2, 2017

terehov commented Jan 3, 2018

ctoLarsson commented Jan 3, 2018

bingimar commented Feb 5, 2018

jidesakin commented Mar 5, 2018

ghost commented Mar 6, 2018

thorntonjohn commented Mar 21, 2018

kidbrax commented May 3, 2018

rouralberto commented Jul 5, 2018

pyrat commented Aug 8, 2018

jjhesk commented Aug 17, 2018

bed42 commented Nov 2, 2018

Jaspur commented Mar 15, 2019

FedeGens commented Apr 16, 2019

pwm commented May 31, 2019

aazcast commented Aug 2, 2019 • edited Loading

stevenleeg commented Sep 6, 2019

striveforbest commented Sep 26, 2019

karam-nus commented Oct 15, 2019 • edited Loading

andresilvagomez commented Nov 7, 2019

leobenkel commented Jul 30, 2020

devglrd commented Aug 16, 2020

juliofalbo commented Sep 24, 2020

barttenbrinke commented Oct 20, 2020

isavita commented Apr 9, 2021

jakob commented Apr 9, 2021

Jaspur commented Apr 9, 2021 via email

tobyhinloopen commented Apr 9, 2021 • edited Loading

rensverschuren commented Apr 11, 2017 •

edited

Loading

billyshena commented May 23, 2017 •

edited

Loading

aazcast commented Aug 2, 2019 •

edited

Loading

karam-nus commented Oct 15, 2019 •

edited

Loading

tobyhinloopen commented Apr 9, 2021 •

edited

Loading