CODEWITHSUNDEEP
postgresqlpgadmin
Hoàng Long
Hoàng Long

Reputation: 10848

Easy way to view data in pgAdmin (PostgreSQL)

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?

Upvotes: 17

Views: 17542

Answers (2)

newenglander
newenglander

Reputation: 2049

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.

Upvotes: 0

hsmiths
hsmiths

Reputation: 1307

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.

Upvotes: 9

Related Questions