pgAdmin

pgAdmin is the most popular and feature-rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

pgAdmin is a management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server. It may be run either as a web or desktop application.

Features and Highlights

• Desktop mode, using a purpose-built runtime
• Server mode, supporting multiple users over the web
• Powerful query tool with color syntax highlighting
• Fast datagrid for display/entry of data
• Graphical query plan display
• Grant Wizard for rapid updates to ACLs
• Procedural language debugger (supporting pl/pgsql and edb-spl)
• Auto-vacuum management
• Monitoring dashboard
• Backup, restore, vacuum and analyze on-demand
• SQL/shell/batch job scheduling agent
• Create, view and edit all common PostgreSQL objects
• Designed for multiple PostgreSQL versions and derivatives

pgAdmin supports most PostgreSQL server-side encodings:

• SQL_ASCII
• EUC_JP, EUC_CN, EUC_KR, 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