Thread: Psql question
Anyone know how to turn off the --MORE-- option when a query returns? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA
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/
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/
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/