Interfaces for PostgreSQL

Two interfaces are provided for accessing your PostgreSQL database, command line and web based.

Command line

To connect from the command, login to your web hosting account via SSH then run:

psql

then, when prompted enter your password.

If you have multiple databases configured for your account, you will need to specify the username and database name as follows:

psql DATABASE_NAME USERNAME 

then, when prompted enter your password.

Web based interface

A web browser based graphical interface called PhpPgAdmin is available via the web hosting control panel