Re: Editable resultset
От | Michal Kozusznik |
---|---|
Тема | Re: Editable resultset |
Дата | |
Msg-id | 50F81D1A.4000009@ifortuna.cz обсуждение исходный текст |
Ответ на | Re: (Edson Richter <edsonrichter@hotmail.com>) |
Ответы |
Re: Editable resultset
|
Список | pgadmin-support |
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
В списке pgadmin-support по дате отправления: