Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

psql query output

Status
Not open for further replies.

LD50

Programmer
Jan 9, 2012
3
0
0
US
Hello,

When I am using psql on a new postgres server, sometimes the results are displayed in a new screen, almost like the result of a MAN command.

I find this very annoying, but I don't know how I set it to always just print query results normally.

Thanks for any help !
 
Hi

I think you mean, the results are displayed in a pager. ( Now you know the keyword to search in the documentation. )

To disable the use of pager you can either :
[ul]
[li]type [tt]\pset pager off[/tt] to the [tt]psql[/tt] prompt or insert this command in a separate line of the ~/.psqlrc file[/li]
[li]start [tt]psql[/tt] with [tt]-P pager=off[/tt] parameter[/li]
[/ul]


Feherke.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top