On 15 sep 2009, at 00.48, Guillaume Lelarge <guilla...@lelarge.info>
wrote:
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?
For long queries the whole string won't be available. Maybe we should
try to detect that and issue an error?
/Magnus
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support