I wonder whether I can edit the content of table in the data output of a query in pgAdmin III? The query is a select * from [...]. MySQL Workbench allows users to edit the content of table in the data output of a query, but I fail to see the same option in pgAdmin III.

  • 1
    Again, Franck, you have come up with a lacuna in the pgAdmin3 tool. This one is, I would argue, more serious than the last one. Perhaps another feature request? Again, I could double check on Windows and Linux.
    – Vérace
    Commented Mar 27, 2016 at 10:16
  • @Vérace Thanks again, you are welcome to post the comment as an answer. Commented Mar 28, 2016 at 18:28
  • You can edit data in pgAdmin III but not in the query output window. Right click table > View data. Table needs a primary key. Commented Mar 28, 2016 at 18:53
  • @NeilMcGuigan Thanks, that's how I do it indeed. I was hoping one could directly edit a table through a query output. Commented Mar 30, 2016 at 3:19

1 Answer 1


Agan, Franck, you have discovered another (serious this time) lacuna in the pgAdmin3 tool. Perhaps you can also put in a feature request for this also.

I tested it on Windows and Linux. If you provide a link here to any feature request, I would only be too glad to put in a "me too" on the wish list (same goes for the other one).

If data is editable, then the user should be allowed to edit the data in a grid like that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.