Thread: Feature request -- export as select into stmts

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

What is the proper way to make a feature request?<br /><br />

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.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

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

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/> 

2010.10.27 15:22, Michael Shapiro rašė:
> 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.
Yes - this kind of tool would be handy in situation when while 
developing applications one uses pgAdmin and later there is a need to 
generate SQL script of changes. Now one is simply forced to write 
inserts manually (that is a bit annoying)...

-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

On 27 October 2010 14:08, Julius Tuskenis <julius@nsoft.lt> wrote:
> 2010.10.27 15:22, Michael Shapiro rašė:
>>
>> 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.
>
> Yes - this kind of tool would be handy in situation when while developing
> applications one uses pgAdmin and later there is a need to generate SQL
> script of changes. Now one is simply forced to write inserts manually (that
> is a bit annoying)...

I guess it also depends on how smart you want it to be.  For example,
if you have a NOT NULL column without a DEFAULT value, which you
haven't included in your select statement, the inserts it generates
won't be valid, at least not for that exact table.  But maybe that's a
bit of a corner case, and plus it might not be a problem, and the user
should probably know better anyway.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

Le 27/10/2010 07:38, Michael Shapiro a écrit :
> I think trying to do this in the query tool (with arbitrary selects) is
> problematic.
> 
> All I really am asking for is that the edit grid be able to produce the
> inserts based on the data it has displayed in the grid.
> 

Which is already a lot of work.

Anyway, as it seems some would need it, I added a ticket for it
(http://code.pgadmin.org/trac/ticket/271).


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com