send psql output to file and setting pager=more

From: kmh496 <kmh496(at)kornet(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: send psql output to file and setting pager=more
Date: 2006-05-20 00:28:46
Message-ID: 1148084926.17869.10.camel@var.sirfsup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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? )

thanks.
joesph.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2006-05-20 03:58:42 Re: send psql output to file and setting pager=more
Previous Message Bruno Wolff III 2006-05-19 15:45:18 Re: OIDS