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)

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.

PostgreSQL visual interface similar to phpMyAdmin?

Tags:

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)

294

asked Apr 20 '11 03:04

Tristan

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.

164

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.

answered Sep 19 '22 12:09

Keith Palmer Jr.

Related questions
                            
                                dbms_lob.getlength() vs. length() to find blob size in oracle
                            
                                Best way to delete millions of rows by ID
                            
                                Watching variables in SSIS during debug
                            
                                MySQL: How to add one day to datetime field in query
                            
                                Can parameterized statement stop all SQL injection?
                            
                                How to use SQL Select statement with IF EXISTS sub query?
                            
                                sqlite copy data from one table to another
                            
                                Table storage engine for <TABLE> doesn't have this option on order by query (ERROR 1031)
                            
                                How to Select a substring in Oracle SQL up to a specific character?
                            
                                LEFT OUTER JOIN in Rails 4
                            
                                ALTER TABLE DROP COLUMN failed because one or more objects access this column
                            
                                #1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)
                            
                                CURRENT_TIMESTAMP in milliseconds
                            
                                How to get First and Last record from a sql query?
                            
                                Boolean 'NOT' in T-SQL not working on 'bit' datatype?
                            
                                MySQL: Curdate() vs Now()
                            
                                Return multiple fields as a record in PostgreSQL with PL/pgSQL
                            
                                SQL Query - Using Order By in UNION
                            
                                MySQL pivot row into dynamic number of columns
                            
                                Synchronizing client-server databases

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With