[stevepike]

I'm still on the hunt for an OSX PostgreSQL client with a table editor as awesome as aqua data studio's [0] (their java client doesn't work great on mac). With ADS you can edit the results of any query as if it was a spreadsheet, hit "save", and ADS will generate the correct insert/update statements for you and run them. It handles copy/paste across multiple rows pretty well, even with thousands of update/inserts, and I haven't found any other editors (I've tried pgadmin, jetbrains thing, navicat, this PSequel, and some others) that do this.

http://www.aquafold.com/aquadatastudio/table_data_editor.htm...

[bsg75]

DbVisualizer has a similar feature, and works as well on a Mac as the Win and Linux versions - subject to occasional issues common to the JRE on your machine.

http://www.dbvis.com/

[stevepike]

Thanks, just tried it out. This is almost there - it doesn't seem to handle copy/pasting multiple rows from excel into the grid.

[captainchaos]

The latest PyCharm 4.0 IDE from JetBrains support just this feature, and it's great. I am guessing that the upcoming 0xDBE will support this in a standalone app if you don't need a full blown IDE for another language outside of SQL.

https://www.jetbrains.com/dbe/

[stevepike]

Looking forward to trying it out! I've got the evaluation version of Intellij IDE and it doesn't handle copy/paste across multiple cells.

[yliang]

Thanks for your suggestion! The feature of editing query results is actually the second highest priority item in my todo list. (The first one is Query Bookmarks.)