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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.