PostgreSQL GUI client.
Version: 2.0 Beta 2Whether you want to learn SQL or need a tool to look at the inner working (see the "Log" on the screen shot below) of the PostgreSQL server while you program a client application for it, EduPhant will be the answer.
Operating System: Mac OS X
You can use EduPhant regardless of your language or favorite operating system since it supports any text encoding PostgreSQL supports and works on Mac OS 8 and 9, OS X, Windows, and we have an experimental build for Linux too now.
Most other SQL clients dumbly enter data in PostgreSQL in their operating system's default text encoding, regardless of the encoding in which your database has been defined. This results in corrupted data that isn't usable cross-platform or with other clients that do respect the text encodings like EduPhant. The corruption is most noticable with non-ASCII characters like an accented "e."
EduPhant's SQL query templates will allow the novices to quickly pick up the SQL syntax and logic, or they will jog the memory of the more advanced users. Plus they make it a breeze to rapidly construct your SQL queries. When you click on cells or headers of the query results table or of the database overview table, you enter their content into your query -- another very practical feature to reduce typing (and typos). You can also store your own custom SQL templates.