Re: Editable resultset

On Thu, Jan 17, 2013 at 3:47 PM, Michal Kozusznik
<kozusznik(dot)michal(at)ifortuna(dot)cz> wrote:
> 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.

It's not a case of voting I'm afraid. It's finding someone with the
time and desire to implement the feature.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company