On Wed, Nov 18, 2009 at 8:55 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> Le lundi 16 novembre 2009 à 19:08:29, Little, Douglas a écrit :
>> Hi,
>> I'm new to this community and not sure how to submit feature request.
>> Please advise.
>>
>> I'm converting from Teradata to greenplum, and one nice feature in our TD
>> query tool was a query history. Timestamp, completion code, rows
>> affected, and sql statement
>>
>> PGadmin seems to be very unstable in our environment, and is crashing all
>> the time. A query history would be real helpful. Thanks
>>
>
> There is already a query history. But we don't record it. It would probably be
> interesting to do it. We need to know more about what you would like to have
> this. In which file should we record this? how someone can work with this
> history file? etc.
It's been on my mental todo list for a while (but feel free to give it
a go). There is/was a similar in the DB2 management GUI which I used a
little a few years back - basically, they have a combo box above the
query input STC (spanning the width of the STC), in which every time
you execute a query, it adds a flattened (ie. \n's replaced with
spaces, double spaces replaced with single) version of the first few
lines to the combo list. If you select one of those queries, it simply
replaces the STC contents with the unflattened version of the original
query.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com