From: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Dave Page <dpage(at)pgadmin(dot)org>, PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Feature request -- export as select into stmts |
Date: | 2010-10-27 12:22:39 |
Message-ID: | AANLkTikt69crKtLsTEi7ovDeqOmMo-zK9O-WRQKrGsEd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Julius Tuskenis | 2010-10-27 13:08:41 | Re: Feature request -- export as select into stmts |
Previous Message | Thom Brown | 2010-10-27 10:46:39 | Re: Feature request -- export as select into stmts |