EMS SQL Manager for PostgreSQL is a powerful graphical tool for PostgreSQL DB Server administration and development.
Features: EMS SQL Manager for PostgreSQL is a database administration and a development tool. This application is specifically designed for the PostgreSQL database. It is compatible with any PostgreSQL versions up to 8.3. The newer features of PostgreSQL are supported also. These include enumerated, text search, XML and UUID data types, index key sorting order, arrays of composite types, and others. Experienced user would be able to use the Visual Database Designer, Visual Query Builder, and powerful BLOB editor features to design their specific schemes. Query building is supported by visual and text tools that help you do this easily. Supports UTF8 data too. Rapid database management and navigation and data manipulation tools make management and navigation easier.This is assisted by a database explorer that helps management of all PostgreSQL objects.
SQL Manager for PostgreSQL has a state-of-the-art graphical user interface. It also has a well-described wizard system. It is easy to use and helps even complete beginners get productive very soon. The visual database designer makes actual designing quite easy. You are able to use the wizards for easy maintenance. It connects through local port forwarding through the SSH tunnel and accesses the PostgreSQL server though HTTP protocol. Multiple host/database connections are supported. It has effective security management mechanisms in place too.It supports ENUM, TSVECTOR, TSQUERY, XML and UUID data types. It also supports index key sorting order suc as ASC, DESC, NULLS FIRST and NULLS LAST. You can set up arrays of composite types.
Overall: It contains a good set of tools for maintenance of and development in PostgreSQl databases.