Re: Psql question

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:mike@fuhr.org]
Sent: Monday, October 25, 2004 1:14 PM
To: Goulet, Dick
Cc: pgsql-admin@postgresql.org
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/