psql query output

[LD50]

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 !

 

[feherke]

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.