101

I'd like to view and possibly edit tables for PostgreSQL visually like phpMyAdmin, where you can see the list of tables, and fields and individual rows for a table. Is there any utility that can do this?

Forgive me if this is actually possible in pgAdmin III, but I couldn't figure out any way to see tables visually in pgAdmin. I have PostgreSQL 8.4 (I actually didn't install it myself, it was installed by another piece of software that utilizes it)

Improve this question
3
  • That list seems to specifically exclude data browsing tools – it's more of a list of GUI utilities, such as exporters, converters, etc. List of GUI/CLI clients: wiki.postgresql.org/wiki/PostgreSQL_Clients Commented Aug 9, 2019 at 18:41
  • this library I created will easy add GUI endpoint for any flask application easy as intergate any flask lib: github.com/MahmoudHegazi/postgresql-admin all you need import phAdmin class: from postgresql_admin import pgAdmin Then provide app, and postgresql database creds (no external requests or save data) pgAdmin(app, user="postgres-user", password="postgresql-pass", host="127.0.0.1", port="5432", default_shecema='postgres') Commented May 1, 2024 at 10:11
  • Please note this tool for Python-Flask and it do same as PhpMyAdmin do for PHP but for python flask, also it not include create table using GUI, and Alter and Stored Procedures, and export and import as well, but it do the main and all you mentioned and the most good it same as phpMyAdmin but for python so it add GUI easy not like pgAdmin that need computer app and link your db server to it then access from db app. Commented May 1, 2024 at 10:30

5 Answers 5

Reset to default
95

phpPgAdmin might work for you, if you're already familiar with phpMyAdmin.

Please note that development of phpPgAdmin has moved to github per this notice but the SourceForge link above is for historical / documentation purposes.

But really there are dozens of tools that can do this.

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

5 Comments

Been playing with Adminer since finding this topic. it is quite fantastic for the occasional web-based database tool need.
This project seems not to be active at all. That last update was 2013.
For the record, @David is talking about phpPgAdmin, not Adminer which is a fantastic and well maintained tool (last uplate as of this comment : 3 weeks ago).
It is 2024-07-04 now and the last updates of the mentioned tools are: phpPgAdmin (2020-11-07), Adminer (2021-05-14), pgAdmin (2024-06-27)
FWIW the active fork as of 2025 appears to be github.com/ReimuHakurei/phpPgAdmin
31

I would also highly recommend Adminer - http://www.adminer.org/

It is much faster than phpMyAdmin, does less funky iframe stuff, and supports both MySQL and PostgreSQL.

Improve this answer

5 Comments

Its ui is quite intuitive. But there is some stupid issues such as json/jsonp data type is not even shown in the data types dropbox, but the last update was April 2015.
It seems like it can't create roles or change database encoding to utf8. Am I missing something? That seems like really basic functionality.
ps, PMA doesn't use iframes since 4.0 - switching entirely to XMLHttpRequests
adminer really has very limited functionality it is good for basic usage not for complex work
this faster and simple: github.com/MahmoudHegazi/postgresql-admin and do all needed for basic, and will improved in future and added to pip so easy install with pip, note you can add it on your servers as well, please give it a look
20

pgAdmin 4 is a powerful and popular web-based database management tool for PostgreSQL - http://www.pgadmin.org/

Improve this answer

5 Comments

How do I view this info in pgadmin though? I'm clicking around under the Databases object and don't see where the tables are listed, or how to browse the data in the tables visually. The only thing I see is under Catalogs>PostgreSQL (pg_catalog)>Tables, but this doesn't actually seem to be a list of tables in the database - it seems to be something else.
Thanks. I see the list of tables, and that if I right-click I can View Data>View Top 100 Rows/View All Rows. Is there any way I can view the rows with a pagination option, like phpmyadmin where you click an arrow for the next page, without having to manually filter the rows myself?
Incredibly bad UX of pgAdmin made me switch back to MySQL. The world's most advanced database has the world's worst admin tool. That mess just destroys your productivity.
pgadmin has a very bad UX, I rather work with a basic tool like adminer
Nice ! However the documentation of version 6 doesn't mention clearly how to bridge it with Apache and I thought it could only work in desktop mode. On Debian machines, the installation script can do this semi-automatically though : pgadmin.org/download/pgadmin-4-apt
1

Azure Data Studio with Postgres addin is the tool of choice to manage postgres databases for me. Check it out. https://learn.microsoft.com/en-us/sql/azure-data-studio/quickstart-postgres?view=sql-server-ver15

Improve this answer

Comments

0

I like HeidiSQL (desktop) for both MySQL/Maria and Postgres

Just did a quick research to see what's new and CloudBeaver looks promising. To run community edition under localhost:8978.

docker run  --network host --name cloudbeaver --rm -ti -p 8978:8978 -v /opt/cloudbeaver/workspace dbeaver/cloudbeaver:latest

Notice --network host to be able to connect to local databases

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.