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

Re: [pgadmin-support] Possible simple enhancement

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-support(at)postgresql(dot)org
Cc: Roger Niederland <roger(at)niederland(dot)com>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Possible simple enhancement
Date: 2009-09-14 22:48:21
Message-ID: 200909150048.22175.guillaume@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
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

Attachment: ticket9_v1.patch
Description: text/x-patch (4.0 KB)

In response to

Responses

pgadmin-hackers by date

Next:From: Magnus HaganderDate: 2009-09-15 04:54:59
Subject: Re: [pgadmin-support] Possible simple enhancement
Previous:From: Guillaume LelargeDate: 2009-09-14 20:24:48
Subject: Re: Ticket #6: Add a cursors list in the server status window

pgadmin-support by date

Next:From: Magnus HaganderDate: 2009-09-15 04:54:59
Subject: Re: [pgadmin-support] Possible simple enhancement
Previous:From: Guillaume LelargeDate: 2009-09-12 12:49:04
Subject: Re: Possible simple enhancement

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