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
1  
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

2 Answers 2

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

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

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.