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.
On Wed, Oct 27, 2010 at 9:29 AM, Thom Brown
<thom@linux.com> wrote:
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)...
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