Re: Feature request -- export as select into stmts

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(at)linux(dot)com> wrote:

> On 27 October 2010 14:08, Julius Tuskenis <julius(at)nsoft(dot)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
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>