Reputation: 1685

PostgreSQL visual interface similar to phpMyAdmin?

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)

Upvotes: 100

Answers (5)

Pawel

Reputation: 18222

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

Upvotes: 0

Ilya Sh

Reputation: 94

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

Upvotes: 1

Peter Eisentraut

Reputation: 36729

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.

Upvotes: 94