btherl Posted December 6, 2006 Share Posted December 6, 2006 I have a very simple question.. how do I get pgsql (the CLI for postgres) to page results even when there's a small number of rows? Often the rows are long, meaning they scroll off the screen even though there are not many rows. pgsql doesn't enable paging because it thinks they will fit.This is driving me crazy :) Please help! Quote Link to comment https://forums.phpfreaks.com/topic/29607-solved-how-to-page-in-pgsql/ Share on other sites More sharing options...
the_oliver Posted December 7, 2006 Share Posted December 7, 2006 how are you trying to view the data? Through a terminal or through php? Quote Link to comment https://forums.phpfreaks.com/topic/29607-solved-how-to-page-in-pgsql/#findComment-136565 Share on other sites More sharing options...
btherl Posted December 7, 2006 Author Share Posted December 7, 2006 Through the terminal, pgsql Quote Link to comment https://forums.phpfreaks.com/topic/29607-solved-how-to-page-in-pgsql/#findComment-136581 Share on other sites More sharing options...
btherl Posted November 13, 2007 Author Share Posted November 13, 2007 Here is the solution:\pset pager alwaysThis line can go in .psqlrc if you want it all the time. Quote Link to comment https://forums.phpfreaks.com/topic/29607-solved-how-to-page-in-pgsql/#findComment-390384 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.