I think the feature you are looking for is obtained using right click
over table and selecting "View data... filtered rows".
> It's live and editable.
>
>
Yes it is. But is not comfy enough for daily work
It is implemented very well in MySQL software (Query Browser and
Workbench). You can edit resultset retrieved by SELECT statement since
it's identified by PK or Unique key, right after executing this statement.
The method provided by pgadmin is not always efficient. There are a few
reasons:
- you cannot define columns set displayed in the grid - with a lot
columns in a table, while not all fit the window, working with it is
annoying
- you cannot change order of displayed columns - as above
- using filter and sort tabs is significantly slower then writing SELECT
in query window
- usually (from experience) you start to work with query window. Then
after got result, you have to execute select via View Data just to be
able to edit it. Sometimes writing update query is faster (again, from
experience)
So, I also vote to make resultsets retrieved by select statement editable.
with regards