Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I go to databases in phpPgAdmin it says that there are 0 databases. Yet, if I run SELECT datname FROM pg_database it displays all databases OK. I would like to be able to 'explore' tables and databases.

share|improve this question
Which account do you use for, respectively, phpPgAdmin and running the SELECT datname FROM pg_database query? –  Milen A. Radev Jun 25 '13 at 18:27
phpPgAdmin probably hides the default databases template0, template1 and postgres by default. If there are other DBs, maybe you're connecting to a different DB server from psql and phpPgAdmin? –  Craig Ringer Jun 26 '13 at 2:47
Milen A. Radev, I use the same account for both running the query and phpPgAdmin. To make matter even more complicated, I run the query from phpPgAdmin which essentialy means that permissions are set correctly. –  sly Jun 26 '13 at 8:42
Craig Ringer, As per my comment above, I run the query from phpPgAdmin and i displays databases ok. –  sly Jun 26 '13 at 8:43
Any luck with this? –  sly Jul 1 '13 at 9:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.