If you're querying from within the psql client program (and it seems
from your question that you are), then the results are reported back via
the utility "less" (or a less-like program internal to psql, can someone
else clarify?) if the results are more than a single page in length. I
don't think you can make the results "swosh", but you can instantly move
to the bottom of the output by hitting "G". That's uppercase "G", not
to be confused with lowercase "g", which is a different command and will
take you to the *top* of the output.
I hope that answers your first question.
As for getting timing information on your queries, the psql client will
do this for you if you enable the option by entering "\timing". Query
timing is off by default, so ordinarily you'd need to enable it every
time you start a new psql session.
Good hunting
BJ
Victor Spång Arthursson wrote:
> Are presently converting from mysql to postgresql, and my first
> newbiequestion is how to make all the rows in a result from a select
> just "swosh" by? That is, I dont want to see them page for page; just
> to scroll by so I can se the last line with the number of
> corresponding rows.
>
> And is there a way to see how long time a query took to execute
> without running a EXPLAIN ANALYSE on the query?
>
> Sincerely
>
> Victor - Copenhagen/Malmoe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
