HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlCritical

How to view data in pgAdmin III

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
pgadminviewhowiiidata

Problem

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?

Solution

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

Context

StackExchange Database Administrators Q#16993, answer score: 57

Revisions (0)

No revisions yet.