Re: Review: query result history in psql - Mailing list pgsql-hackers

From ian link
Subject Re: Review: query result history in psql
Date
Msg-id CAOOwM5+37pRWXr2j_sAq7HLhJ20T5805O_9+0z5t8prp0m2KgA@mail.gmail.com
Whole thread
In response to Re: Review: query result history in psql  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
I'm kinda not all that convinced that this feature does anything
that's actually useful.  If you want to save your query results, you
can just stick "CREATE TEMP TABLE ans AS" in front of your query.
What does that not give you that this gives you?
Convenience. It auto-increments with each new query, giving you a different temporary table for each query. Seems pretty helpful to me.


On Tue, Jul 2, 2013 at 6:16 PM, Robert Haas <robertmhaas@gmail.com> wrote:
On Tue, Jul 2, 2013 at 8:16 PM, ian link <ian@ilink.io> wrote:
> We covered that earlier in the email thread, but it's the current name for
> the query history. I think we are going to change it to something a little
> more descriptive. I was thinking "qh" for short or "query-history".
>
>> I'm not sure if I'll be able to implement this feature any time soon,
>> as I'm very busy at the moment and going for a business trip in few
>> days.
>
> I can try implementing the feature, I might have some time.

I'm kinda not all that convinced that this feature does anything
that's actually useful.  If you want to save your query results, you
can just stick "CREATE TEMP TABLE ans AS" in front of your query.
What does that not give you that this gives you?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Review: query result history in psql
Next
From: "Etsuro Fujita"
Date:
Subject: Re: Patch for removng unused targets