67

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?

0

3 Answers 3

57

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

2
  • 3
    Is there any way to make it not open in a new window?
    – Dennis
    Commented May 26, 2014 at 19:20
  • 1
    @Dennis: None that I know of. If you want to refresh the already open window just press [F5]. Commented May 26, 2014 at 21:13
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

0
4

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

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.