Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 576
Hoàng Long Avatar asked May 05 '11 03:05

Hoàng Long


People also ask

How can you view the data via pgAdmin?

To view or modify data, right click on a table or view name in the Browser tree control. When the context menu opens, use the View/Edit Data menu to specify the number of rows you would like to display in the editor panel. To modify the content of a table, each row in the table must be uniquely identifiable.

How do I show data in PostgreSQL?

Use the \dt or \dt+ command in psql to show tables in a specific database. Use the SELECT statement to query table information from the pg_catalog.

How do you view output in pgAdmin 4?

If the Scratch Pad is closed, it can be re-opened (or additional ones opened) by right-clicking in the SQL Editor and other panels and adding a new panel. The lower panel displays the Data Output panel.


1 Answers

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.

like image 76
hsmiths Avatar answered Oct 17 '22 06:10

hsmiths