Re: send psql output to file and setting pager=more

On 5/20/06, kmh496 <kmh496(at)kornet(dot)net> wrote:
> hello list.
>
> these are just 2 very short questions.
>
> is it possible in psql to ......
> (1) i want it to stop after a screen of information.
> i.e. like mysql's "[mysqld] pager=more .." my.cnf directive.
>
> (2) also, i want to have the results show up on the screen and be tee-ed
> to a file. Oracle can do this, i don't remember if it's "set server
> output on" or something like that?
> i tried
> \g out
> but the file still had old information in it.
> ( \g defaults to cwd yes? )
What OS are you using postgres under?

Under Linux you can quite easily just run the command
non-interactively and actually paginate via less or more;

Alternatively, under psql (man psql for details :P) you can
use \pset pager less.

> thanks.
> joesph.
Cheers,
Andrej