Re: Feature request -- export as select into stmts
От | Michael Shapiro |
---|---|
Тема | Re: Feature request -- export as select into stmts |
Дата | |
Msg-id | AANLkTikt69crKtLsTEi7ovDeqOmMo-zK9O-WRQKrGsEd@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Feature request -- export as select into stmts (Thom Brown <thom@linux.com>) |
Ответы |
Re: Feature request -- export as select into stmts
|
Список | pgadmin-support |
My apologies. I had sent email to this list last Feb with this request<br /><br /><div style="margin-left: 40px;">It wouldbe very useful to be able to export the results of a query as select into statements, at least in the case when thereis only one table in the from clause.<br /></div><br />I didn't get a reply, so I thought I was asking on the wronglist. When I sent the question about how to ask for a feature, I didn't change the subject, but also didn't includethe request.<br /><br />Thom Brown has it basically right. I want to be able to take the results of what is in thegrid editor and produce insert stmts. Perhaps an option under Edit Data/Tools?<br /><br /><div class="gmail_quote">OnWed, Oct 27, 2010 at 5:46 AM, Thom Brown <span dir="ltr"><<a href="mailto:thom@linux.com">thom@linux.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">On 27 October 2010 11:42,Guillaume Lelarge <<a href="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>> wrote:<br /> > Le 27/10/201001:12, Dave Page a écrit :<br /> >> On Wed, Oct 27, 2010 at 1:47 AM, Michael Shapiro <<a href="mailto:mshapiro51@gmail.com">mshapiro51@gmail.com</a>>wrote:<br /> >>> What is the proper way to make afeature request?<br /> >><br /> >> Email the list, as you've done.<br /> >><br /> ><br /> > Usually,if I find it interesting, I create a ticket to keep track of<br /> > it. But honestly, I don't understand whatis the feature that you want.<br /><br /></div>I think he wants to be able to use:<br /><br /> SELECT col_a, col_c, col_gFROM my_table LIMIT 3;<br /><br /> to produce something like<br /><br /> INSERT INTO my_table (col_a, col_c, col_g)VALUES (1, 'stuff', true);<br /> INSERT INTO my_table (col_a, col_c, col_g) VALUES (2, 'things', true);<br /> INSERTINTO my_table (col_a, col_c, col_g) VALUES (6, 'misc', false);<br /><font color="#888888"><br /> --<br /> Thom Brown<br/> Twitter: @darkixion<br /> IRC (freenode): dark_ixion<br /> Registered Linux user: #516935<br /></font></blockquote></div><br/>
В списке pgadmin-support по дате отправления: