Re: Feature request -- export as select into stmts

My apologies. I had sent email to this list last Feb with this request

It would be very useful to be able to export the results of a query as
select into statements, at least in the case when there is only one table in
the from clause.

I didn't get a reply, so I thought I was asking on the wrong list. When I
sent the question about how to ask for a feature, I didn't change the
subject, but also didn't include the request.

Thom Brown has it basically right. I want to be able to take the results of
what is in the grid editor and produce insert stmts. Perhaps an option under
Edit Data/Tools?

On Wed, Oct 27, 2010 at 5:46 AM, Thom Brown <thom(at)linux(dot)com> wrote:

> On 27 October 2010 11:42, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
> > Le 27/10/2010 01:12, Dave Page a écrit :
> >> On Wed, Oct 27, 2010 at 1:47 AM, Michael Shapiro <mshapiro51(at)gmail(dot)com>
> wrote:
> >>> What is the proper way to make a feature request?
> >>
> >> Email the list, as you've done.
> >>
> >
> > Usually, if I find it interesting, I create a ticket to keep track of
> > it. But honestly, I don't understand what is the feature that you want.
>
> I think he wants to be able to use:
>
> SELECT col_a, col_c, col_g FROM my_table LIMIT 3;
>
> to produce something like
>
> INSERT INTO my_table (col_a, col_c, col_g) VALUES (1, 'stuff', true);
> INSERT INTO my_table (col_a, col_c, col_g) VALUES (2, 'things', true);
> INSERT INTO my_table (col_a, col_c, col_g) VALUES (6, 'misc', false);
>
> --
> Thom Brown
> Twitter: @darkixion
> IRC (freenode): dark_ixion
> Registered Linux user: #516935
>