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 />