Re: Feature request -- export as select into stmts - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: Feature request -- export as select into stmts
Date
Msg-id AANLkTikt69crKtLsTEi7ovDeqOmMo-zK9O-WRQKrGsEd@mail.gmail.com
Whole thread
In response to Re: Feature request -- export as select into stmts  (Thom Brown <thom@linux.com>)
Responses Re: Feature request -- export as select into stmts
List 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@linux.com> wrote:
On 27 October 2010 11:42, Guillaume Lelarge <guillaume@lelarge.info> wrote:
> Le 27/10/2010 01:12, Dave Page a écrit :
>> On Wed, Oct 27, 2010 at 1:47 AM, Michael Shapiro <mshapiro51@gmail.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

pgadmin-support by date:

Previous
From: Thom Brown
Date:
Subject: Re: Feature request -- export as select into stmts
Next
From: Julius Tuskenis
Date:
Subject: Re: Feature request -- export as select into stmts