Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
pgadmin is disgusting, had to google to find what has to be undoubtably the most common function, what a joke gaaah rantttt –  amiawizard Dec 14 '13 at 12:19
add comment

2 Answers

up vote 9 down vote accepted

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

share|improve this answer
add comment

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

share|improve this answer
    
Thank you for your answer. I recently had to switch from MySQL, where I was using MySQLAdmin. My primary use case is for viewing data, and not gathering statistics about performance. pgAdmin III seems to be for a different use case. Thank you for the wiki article, which I looked through. There are a lot there. Do you have a preference? –  Alexis K Apr 25 '12 at 15:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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