Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group