Psql question

[Goulet, Dick]

Anyone know how to turn off the --MORE-- option when a query returns?

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Michael Fuhr]

Post by Goulet, Dick
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.

[Goulet, Dick]

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:***@fuhr.org]
Sent: Monday, October 25, 2004 1:14 PM
To: Goulet, Dick
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] Psql question

Post by Goulet, Dick
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 ***@postgresql.org

[Michael Fuhr]

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