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 derfloh 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
Joined
Jan 9, 2012
Messages
3
Location
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