Thread: Edit data on the data output tab

Edit data on the data output tab

From
"Nelson A. de Oliveira"
Date:
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


Re: Edit data on the data output tab

From
Guillaume Lelarge
Date:
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



Re: Edit data on the data output tab

From
Claudio Freire
Date:
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.


Re: Edit data on the data output tab

From
Michael Shapiro
Date:
One idea is to provide a dialog that asks for the table and columns to use for the insert stmts.<br />That way the user
candefine the insert without having to actually export the data and write scripts to produce the inserts<br /> And it
wouldallow inserts into different tables than were used in the select.<br /><br /><br /><br /><div
class="gmail_quote">OnThu, Jul 19, 2012 at 2:30 PM, Guillaume Lelarge <span dir="ltr"><<a
href="mailto:guillaume@lelarge.info"target="_blank">guillaume@lelarge.info</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Thu, 2012-07-19 at 11:39
-0300,Nelson A. de Oliveira wrote:<br /> > Hi!<br /> ><br /> > We can edit the data from a table by using View
Data→ View Filtered<br /> > Rows, but we can't edit the same data when running the same query in<br /> > the SQL
Editor.<br/> > Is it possible to be able to edit the data when viewing it via the<br /> > Data Output in the SQL
Editortoo?<br /> ><br /><br /> No. And I don't see how we would be able to do that. Even if you simply<br /> do a
"SELECT* FROM something", that "something" may be many thing: a<br /> table of course, but also a view, a foreign
table.<br/><br /> So, no, sorry. (no as in "not me")<br /><span class="HOEnZb"><font color="#888888"><br /><br /> --<br
/>Guillaume<br /><a href="http://blog.guillaume.lelarge.info" target="_blank">http://blog.guillaume.lelarge.info</a><br
/><ahref="http://www.dalibo.com" target="_blank">http://www.dalibo.com</a><br /><br /><br /> --<br /> Sent via
pgadmin-supportmailing list (<a href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br />
Tomake changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></span></blockquote></div><br />