Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PostgreSQL visual interface similar to phpMyAdmin?

Tags:

sql

postgresql

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)

like image 294
Tristan Avatar asked Apr 20 '11 03:04

Tristan


People also ask

Is there a phpMyAdmin for PostgreSQL?

The answer is no. There's no phpMyAdmin for PostgreSQL. If that's what you want, then try TablePlus. TablePlus is a native database client that offers GUI tools to develop, manage and maintain multiple databases simultaneously. Native build for Mac, and Windows.

Is there a GUI for PostgreSQL?

pgAdmin is the only PostgreSQL native GUI — plus, it's totally free and scales easily across multiple servers. pgAdmin makes for a great choice for Postgres-focused DBAs.

What is PostgreSQL most similar to?

The best alternative is SQLite, which is both free and Open Source. Other great apps like PostgreSQL are MongoDB, MySQL Community Edition, MariaDB and Microsoft SQL Server. PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development...


2 Answers

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.

like image 164
Peter Eisentraut Avatar answered Sep 22 '22 12:09

Peter Eisentraut


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.

like image 23
Keith Palmer Jr. Avatar answered Sep 19 '22 12:09

Keith Palmer Jr.