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! 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? 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 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. 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
Archived
This topic is now archived and is closed to further replies.