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?
Postgresql – How to view data in pgAdmin III
pgadmin-3postgresql
Related Question
- Postgresql – Slony not replicating changes from a dump file
- PostgreSQL not working, pgAdmin always says server not listening
- Postgresql – Restore Postgresql data after hdd crash
- Postgresql – pgAdmin crashes or freezes when big MATERIALIZED VIEWs are refreshing
- Postgresql – How to set default schema for PostgreSQL debugger
- Postgresql – Why can’t pgAdmin3 connect to Postgres
- Postgresql – Equivalent of PGAdmin III Server Status Activity Window in PGAdmin 4 v5
Best Answer
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).