On Tue, 28 Oct 2003, [ISO-8859-1] 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.
I believe
\pset pager off
will turn off the pager in psql
> And is there a way to see how long time a query took to execute without
> running a EXPLAIN ANALYSE on the query?
In psql you can also use \timing to turn on/off a printing of how many ms
the query took (including data transfer time iirc) after the result set is
printed.