Easy way to view data in pgAdmin (PostgreSQL)

Question

I have searched this problem for more than an hour without any clue. In Heidi SQL (for MySQL), I just need few clicks to open any table to view its data. But in pgAdmin, I must collapse many sub-folder to do that: database/Schemas/public/Tables/... and then I must right click on a table to "view data". It's 3 times slower.

I wonder if there is any easier way to look through PostgreSQL data? Or is there any other way for Postgres that allow me to make it faster?

I can't believe now it's 2021, 10 years has passed and still I have to go through so many steps just to view data in pgAdmin ! — Ken Ratanachai S.
– Ken Ratanachai S., Commented Jun 24, 2021 at 3:44
It really is. However I have switched to Heidi SQL since now they support PostGres as well :) — Hoàng Long
– Hoàng Long, Commented Jun 24, 2021 at 3:58
Tried to try HeidiSQL today, and just realized that it's only for Windows not Mac. So I found TablePlus. Not bad for browsing data. — Ken Ratanachai S.
– Ken Ratanachai S., Commented Jul 1, 2021 at 8:04

hsmiths · Accepted Answer · 2011-05-05 03:22:52Z

9

Go to the properties of your server and check the "restore env" checkbox. That option causes pgadmin to remember your navigation between sessions. It will take you right to the table you selected last time you used pgadmin.

answered May 5, 2011 at 3:22

hsmiths

1,32714 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Hoàng Long Over a year ago

thanks, though it's checked by default. But I still need to right-click, and navigate to "View Data/View 100 rows"? Is there any elegant way to do that?

hsmiths Over a year ago

On the toolbar is an icon that looks like a grid. Click it to view the data in the selected table.

Hoàng Long Over a year ago

Now I realize Ctrl-D or Ctrl-G work too. It should be more user-friendly for such a good DBMS. Thanks for your help.

KindOfGuy Over a year ago

Couldn't agree more. There has got to be a better workflow. By comparison with, say phpMyAdmin, this is pretty bad. Are we missing something?

Kelsey Hannan Over a year ago

PGAdmin's design is laughably bad. I've never seen such an absurd or complex way to present basic data to people. 99% of users don't care about materialized views or foreign_key constraints: they just want to see what data they have in their tables.

newenglander · Accepted Answer · 2011-07-15 14:19:03Z

0

If you set up an ODBC connection to the database, you can access it in Microsoft Access. You can then add the tables you view most often (assuming they're not so many of them) and save them (linked rather than copied) for quick viewing and editing.

answered Jul 15, 2011 at 14:19

newenglander

2,04924 silver badges55 bronze badges

Collectives™ on Stack Overflow

Easy way to view data in pgAdmin (PostgreSQL)

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related