The best GUI for PostgreSQL I've ever seen is the one that is bundled in IntelliJ IDEA as a plugin (Database Tools and SQL). Autocompletion is amazing, lots of features.