Thanks, that worked.  Now does Pgsql support a script like Oracle's
login.sql. 


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Michael Fuhr [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 25, 2004 1:14 PM
To: Goulet, Dick
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Psql question

On Mon, Oct 25, 2004 at 12:15:32PM -0400, Goulet, Dick wrote:
> Anyone know how to turn off the --MORE-- option when a query returns?

\pset pager

This should toggle whether paging is used or not.  You could also
temporarily set the PAGER environment variable to "cat" or some other
program that doesn't page.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to