Thread: 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.<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 />