Using pgAdmin III, I ran the following command to generate 100,000 random records.
create table t_random as select s, md5(random()::text) from generate_Series(1, 100000) s;
I then did as MarcinS suggested in his answer:
"right click on it in Object browser, choose View Data from context menu, You will have options to View Top 100 Rows or View Last 100 Rows"
And I do indeed get the first 100 rows. But then, try as I might, I can't go on to the next 100.
AIUI, you want the first 100 to spring up quickly and then be able to scroll through the remaining ones - i.e. not to be kept waiting while 500k+ records are retrieved?
I believe that I know what you're getting at - I've had to do this sort of mind-numbing stuff for College projects - sometimes there's no substitute for "eye-balling" your data.
So, as far as I'm concerned, the available functionality is not "paging" as I would understand it.
If you'd care to put in a feature request, I'd be only too happy to file a "me-too" if you provide a link to your request.