I have been it in two steps but sometimes I jump on to another task and forget that I have an open transaction and shut down the app.
Anyway I would like to request a feature to let me see intermediate results because for me anyway it's not unusual to chain multiple statements together. Thanks. On Sat, Apr 11, 2015 at 2:50 AM, Guillaume Lelarge <guilla...@lelarge.info> wrote: > Hi, > > 2015-04-10 1:13 GMT+02:00 Tim Uckun <timuc...@gmail.com>: > >> I want to to do the following. >> >> begin; >> explain analyze blah >> rollback; >> >> If I do this I don't get the results of the analyze. >> >> I have been resorting to commenting out the rollback and running it >> separately but it's a bit of a pain. >> >> Is there an easier way to do this? >> >> > Nope. The query tool gets the result of the last query only. So you need > to do it in two steps. > > > -- > Guillaume. > http://blog.guillaume.lelarge.info > http://www.dalibo.com >