What are my options for GUI based Administration & Management of PostgreSQL

I have been given the task of working with PostgreSQL 9.1. I have previously worked with Microsoft SQL, and had used the SQL Management Studio. I had used Oracle's SQL developer as well as TOAD when I had to deal with Oracle.

When Compared to such tools, the pgAdmin seems rather limited. I have checked the list at http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools#Lightning_Admin_for_PostgreSQL but many of links I checked were dead.

I would like something which gives me the following features:

• Import and Export of data into various formats like .xls/.xlsx, .csv

etc

• Ability to see the data in the tables without having to click so much. (for example, in Oracle's SQL developer, once I sign in, I can see the data in my tables in 3 clicks; In pgAdmin, I have to navigate through the hierarchy, to reach my table, and then rightclick to get the 'View Top 100 Rows option')

• Append data from an external source (.xls/.csv) to an existing Table.

• Intelisence/ Code Completion while writing SQL commands.

you can check EnterpriseDB PEM. http://www.enterprisedb.com/products-services-training/products/postgres-enterprise-manager

StackExchange Database Administrators Q#28785, answer score: 2