Thread: Psql question

Psql question

From
"Goulet, Dick"
Date:
Anyone know how to turn off the --MORE-- option when a query returns?

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

Re: Psql question

From
Michael Fuhr
Date:
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/

Re: Psql question

From
"Goulet, Dick"
Date:
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/

Re: Psql question

From
Michael Fuhr
Date:
On Mon, Oct 25, 2004 at 01:20:01PM -0400, Goulet, Dick wrote:

> Now does Pgsql support a script like Oracle's login.sql.

You can put startup commands in $HOME/.psqlrc.  For more info about
psql's capabilities, see the documentation:

http://www.postgresql.org/docs/7.4/static/app-psql.html

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