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  (Julius Tuskenis <julius@nsoft.lt>)
Список 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 по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Feature request -- export as select into stmts
Следующее
От: Julius Tuskenis
Дата:
Сообщение: Re: Feature request -- export as select into stmts