Skip site navigation (1) Skip section navigation (2)

Re: Feature request -- export as select into stmts

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Julius Tuskenis <julius(at)nsoft(dot)lt>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Feature request -- export as select into stmts
Date: 2010-10-27 14:38:06
Message-ID: AANLkTin1zqgZj9gaSyAUTtcSWJAU8n3Pxv5eScFmPeSz@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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
>

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-10-27 15:42:09
Subject: Re: Feature request -- export as select into stmts
Previous:From: Thom BrownDate: 2010-10-27 14:29:14
Subject: Re: Feature request -- export as select into stmts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group