Le samedi 12 septembre 2009 à 14:49:04, Guillaume Lelarge a écrit :
> Le mercredi 9 septembre 2009 à 20:46:00, Roger Niederland a écrit :
> > First of all thanks for PGAdmin I've been using it for years now.
> >
> :)
> :
> > One small enhancement that would be very useful is:
> >
> > When viewing the Statistics tab for the server where the Current
> > Executing Queries is available (along with the current user, database
> > etc..) It would be good to be able to copy the sql of a current query.
> > I realize that it is impractical to show the full query sql (and do not
> > want this). But I would like to be able to copy the "full sql" of the
> > current query. I know that I can log long running queries, but feel it
> > would be useful to copy the query from the statistics, so I can paste it
> > into a query window for further analysis.
>
> It's already possible in 1.10, but it copies the whole line (not only the
> query). Anyways, that's one item on my todolist. We also want to be able to
> launch the query tool with this query (see
> http://code.pgadmin.org/trac/ticket/9). I hope all of these will be in
> 1.12.
>
Here is a patch to lauch the query tool with the selected query. The icon is
the copy one. Not great, but I don't really have design skills. I wonder if we
can make the query tool icon smaller enough, so that it will fit in the
toolbar. Anyways, with this patch, when you click on the toolbar button, the
query tool opens a new connection on the selected database of the same server,
displays the query and allows the user to modify/execute it.
Comments?
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com