The web based interface which allows you to manage your PostgreSQL is called PhpPGAdmin. To create databases, create tables, alter tables and query their own data using industry-standard SQL, to provide this, it is a web-based client which leverages PHP scripting and the PostgreSQL database conveniently to users.