How to view data in pgAdmin III
Or, to retrieve all rows, just press the blue data grid.



The tooltip "View data in the selected object" is almost making it too easy.
Try the button with the funnel next to it to retrieve only a selection (for big tables).