Easy way to view data in pgAdmin (PostgreSQL)

postgresql pgadmin
Hoàng Long picture Hoàng Long · May 5, 2011 · Viewed 13.4k times · Source

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?

Answer

hsmiths picture hsmiths · May 5, 2011

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.

Related questions

Postgresql: password authentication failed for user "postgres"

I have installed PostgreSQL 8.4, Postgres client and Pgadmin 3. Authentication failed for user "postgres" for both console client and Pgadmin. I have typed user as "postgres" and password "postgres", because it worked before. But now authentication is failed. I did it …

Read More
How connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using psql --version on terminal I get psql (PostgreSQL) 9.3.4 then I installed pgadmin with sudo apt-get install pgadmin3 Later I opened the UI and create the server …

Read More
Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on backup, then in Format choice Plain and save file as some_name.sql Then I remove table. Ok, now I …

Read More