PostgreSQL visual interface similar to phpMyAdmin?

Question

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)

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: https://wiki.postgresql.org/wiki/PostgreSQL_Clients — Illya Moskvin, Aug 09 '19 at 18:41

score 91 · Accepted Answer · edited Nov 23 '19 at 09:05

91

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.

edited Nov 23 '19 at 09:05

answered Apr 20 '11 at 06:25

Peter Eisentraut

35,221
12
85
90

12

Been playing with [Adminer](http://www.adminer.org/) since finding this topic. it is quite fantastic for the occasional web-based database tool need. – peelman Jan 08 '13 at 06:32
9

This project seems not to be active at all. That last update was 2013. – David Jul 02 '15 at 17:34
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). – Leogout Dec 03 '20 at 09:44

score 29 · Answer 2 · edited Jan 30 '17 at 21:18

29

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.

edited Jan 30 '17 at 21:18

Cedric

3,074
1
20
22

answered Oct 24 '14 at 16:33

Keith Palmer Jr.

27,666
16
68
105

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. – David Jul 02 '15 at 17:36
It seems like it can't create roles or change database encoding to utf8. Am I missing something? That seems like really basic functionality. – Mark Nov 15 '16 at 10:17
1

ps, PMA doesn't use iframes since 4.0 - switching entirely to XMLHttpRequests – hanshenrik Feb 23 '17 at 00:06
adminer really has very limited functionality it is good for basic usage not for complex work – mohas Mar 04 '21 at 11:33

score 19 · Answer 3 · edited Mar 20 '19 at 00:36

19

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

edited Mar 20 '19 at 00:36

Christopher K.

1,015
12
18

answered Apr 20 '11 at 03:38

Tyler Eaves

12,879
1
32
39

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. – Tristan Apr 20 '11 at 11:53
1

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? – Tristan Apr 24 '11 at 12:23
4

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. – user0103 Oct 01 '19 at 12:50
pgadmin has a very bad UX, I rather work with a basic tool like adminer – mohas Mar 04 '21 at 11:33
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 : https://www.pgadmin.org/download/pgadmin-4-apt/ – Franck Theeten Mar 28 '22 at 19:15

score 2 · Answer 4 · answered Dec 18 '20 at 15:14

2

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

answered Dec 18 '20 at 15:14

Ilya Sh

96
4

PostgreSQL visual interface similar to phpMyAdmin?

4 Answers4

Linked