Getting started with pgadmin4
Not sure how many postgres users there are out there - but you may be interested in the latest version of pgadmin (version 4 beta) - this is traditionally a GUI based front end postgresql that provides easy access to manage and explore local and remote postgresql database instances.
The latest iteration is a complete rewrite - it is a web based application written in python flask (using a bootstrap and jquery front end). A native QT wrapper is also available that bundles the python app and basically injects the web interface into the frame.
There is a lot to like about this release - firstly it is web-based meaning you can run it directly on your database server, it provides all of the main features of pgadmin3 - there are a few things missing (like the quick report function for producing html formatted reports - and the ability to quickly insert a record whilst in table mode).
It does introduce sql completion which is kind of handy (just hit ctrl+space and it will provide a list of table or column suggestions). It also has a dashboard view that provides realtime database server metrics.
It also provides tabs - you can write multiple queries in different tabs (allowing you to easily jump between different queries and result sets).
Here are some installation (and execution) instructions (python 2 only).
1. Download
Download pgadmin4-1.0_beta1-py2-none-any.whl from https://www.pgadmin.org/download/pip4.php
2. Install
virtualenv ~/bin/virtualenv_pgadmin
. ~/bin/virtualenv_pgadmin/bin/activate
pip install ~/Downloads/pgadmin4-1.0b2-py2-none-any.whl
cd ~/bin/virtualenv_pgadmin/lib/python2.7/site-packages/pgadmin4
cp config.py config_local.py
3. Run!
python./pgadmin4.py
It will ask you to enter an email address (and password to log in to the webapp).