Обсуждение: Edit data on the data output tab

Hi!

We can edit the data from a table by using View Data → View Filtered
Rows, but we can't edit the same data when running the same query in
the SQL Editor.
Is it possible to be able to edit the data when viewing it via the
Data Output in the SQL Editor too?

Thank you!

Best regards,
Nelson

On Thu, 2012-07-19 at 11:39 -0300, Nelson A. de Oliveira wrote:
> Hi!
>
> We can edit the data from a table by using View Data → View Filtered
> Rows, but we can't edit the same data when running the same query in
> the SQL Editor.
> Is it possible to be able to edit the data when viewing it via the
> Data Output in the SQL Editor too?
>

No. And I don't see how we would be able to do that. Even if you simply
do a "SELECT * FROM something", that "something" may be many thing: a
table of course, but also a view, a foreign table.

So, no, sorry. (no as in "not me")


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

On Thu, Jul 19, 2012 at 4:30 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> No. And I don't see how we would be able to do that. Even if you simply
> do a "SELECT * FROM something", that "something" may be many thing: a
> table of course, but also a view, a foreign table.
>
> So, no, sorry. (no as in "not me")

A few simple queries against pg_class, pg_constraint and pg_attribute
could answer whether it's possible to edit in-place and how (find
PKs), but the required queries would be bothersome against slow
connections, and would have to be executed for each query because each
case will be somewhat unique.

Somehow, though a useful feature, I cannot see a way to implement it
in a useful and non-intrusive way.

One idea is to provide a dialog that asks for the table and columns to use for the insert stmts.
That way the user can define the insert without having to actually export the data and write scripts to produce the inserts
And it would allow inserts into different tables than were used in the select.