pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPsql question
4+ messages / 2 participants
[nested] [flat]
* Psql question
@ 2004-10-25 16:15 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 1 reply; 4+ messages in thread
From: Goulet, Dick @ 2004-10-25 16:15 UTC (permalink / raw)
To: pgsql-admin
Anyone know how to turn off the --MORE-- option when a query returns?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Psql question
@ 2004-10-25 17:14 Michael Fuhr <mike@fuhr.org>
parent: Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Fuhr @ 2004-10-25 17:14 UTC (permalink / raw)
To: Goulet, Dick <DGoulet@vicr.com>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Psql question
@ 2004-10-25 17:20 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 1 reply; 4+ messages in thread
From: Goulet, Dick @ 2004-10-25 17:20 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Psql question
@ 2004-10-25 17:30 Michael Fuhr <mike@fuhr.org>
parent: Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Fuhr @ 2004-10-25 17:30 UTC (permalink / raw)
To: Goulet, Dick <DGoulet@vicr.com>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-10-25 17:30 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-25 16:15 Psql question Goulet, Dick <DGoulet@vicr.com>
2004-10-25 17:14 ` Michael Fuhr <mike@fuhr.org>
2004-10-25 17:20 Re: Psql question Goulet, Dick <DGoulet@vicr.com>
2004-10-25 17:30 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox