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

Re: [pgadmin-support] Possible simple enhancement

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>, Roger Niederland <roger(at)niederland(dot)com>, "pgadmin-hackers(at)postgresql(dot)org" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgadmin-support] Possible simple enhancement
Date: 2009-09-15 04:54:59
Message-ID: D6091FCF-38AF-4B81-BAA7-4226C23B25D7@hagander.net (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
On 15 sep 2009, at 00.48, Guillaume Lelarge <guillaume(at)lelarge(dot)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


In response to

Responses

pgadmin-hackers by date

Next:From: Quan ZongliangDate: 2009-09-15 05:08:52
Subject: It seems to miss PQclear function
Previous:From: Guillaume LelargeDate: 2009-09-14 22:48:21
Subject: Re: [pgadmin-support] Possible simple enhancement

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2009-09-15 05:34:48
Subject: Re: [pgadmin-support] Possible simple enhancement
Previous:From: Guillaume LelargeDate: 2009-09-14 22:48:21
Subject: Re: [pgadmin-support] Possible simple enhancement

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