How to view data in pgAdmin III

Question

I can't believe they make it this hard. I am at a loss about how to view the data in my database.

Is there an easy way to see what data is in my tables with pgAdmin III? Alternatively, is there a program that I could use that does not suck?

Erwin Brandstetter · Accepted Answer · 2012-05-05T20:32:17.377

58

Or, to retrieve all rows, just press the blue data grid.

enter image description here

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).

edited May 05 '12 at 20:32

answered May 05 '12 at 19:41

Erwin Brandstetter

185,527
28
463
633

score 25 · Answer 2 · answered Apr 25 '12 at 10:06

25

Right click on the table and choose "View data"

enter image description here

For a list of alternatives, check out the Postgres wiki:
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

answered Apr 25 '12 at 10:06

score 4 · Answer 3 · answered Sep 26 '22 at 09:39

4

For pgAdmin 4: Servers -> your_server -> Databases -> your_database -> Schemas -> public -> Tables

answered Sep 26 '22 at 09:39

GorvGoyl

149
3

How to view data in pgAdmin III

3 Answers3