Graphical query designer for PostgreSQL

Question

I have for years used MS Access and its query tool that is used for making queries. This tool is so good that I have never been forced to do very much SQL programming myself. The query tool has done all the work.

However, now I have started using Postgres and the Graphical Query Builder in pgAdmin. It seems that the Graphical Query Builder is rather primitive: It cannot be used if you need an aggregate function like SUM or COUNT.

Is this really correct?

Does anybody know a better graphical query builder for PostgreSQL?

Until now I have 'solved' the problem by linking MS Access to the Postgres database through ODBC and used MS Access' query tool to generate SQL commands which I then copy into pgAdmin's Graphical Query Builder - and edit the SQL commands until everything is correct.

Solution

SQL Maestro has a query designer, although it is PC only, AFAIK

http://www.sqlmaestro.com/products/postgresql/maestro/screenshots/getting_started/visual_query_builder/

EMS SQL Manager also has a query designer

http://www.sqlmanager.net/en/products/postgresql/manager/screenshots

Comments

[Ramos]

And for Linux? There are something?