pgAdmin

pgAdmin is the most popular and feature-rich open source administration and development environment for PostgreSQL, the world's most powerful open source database. 
pgAdmin is an administration tool for PostgreSQL and other relational databases, including EnterpriseDB's EDB Advanced Server. It can be operated as either a web or desktop program.

Features & Highlights 

• Desktop mode, utilizing a purpose-built runtime 
• Server mode allows for numerous web users and includes a powerful query tool with color syntax highlighting. Fast datagrid for data display and entry, with graphed query plans. 
• Grant Wizard for quick ACL updates. 
• Procedural language debugger (supports pl/pgsql and edb-spl). 
• Autovacuum management 
• Monitoring Dashboard 
• On-demand backup, restoration, vacuum, and analysis with SQL, shell, and batch job scheduling. 
• Create, inspect, and edit all the usual PostgreSQL objects. 
• Designed to support many PostgreSQL versions and variants. 

pgAdmin supports the majority of PostgreSQL's server-side encodings:

• SQL_ASCII: EUC_JP, EUC_CN, EUC_KR, and EUC_TW. 
• JOHAB 
• LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10 
• ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8 UNICODE/UTF-8 MULE_INTERNAL KOI8 WIN ALT WIN1256 TCVN WIN874.