SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provides a Java Runtime Environment.
It's main focus is on running SQL scripts (either interactively or as a batch), graphical query building or administration of the database is not the focus.
In order to display geometry data as text (i.e. as WKT) in SELECT statements, follow the following instructions (from: http://www.sql-workbench.net/dev-history.txt > Build 102.8,31.12.2008)
> Enh: (102.7) for specific datatypes, data retrieval in the DbExplorer can now > be done by applying expressions to the column when building the SQL > to select the data.
So, for every DB there are configurations entries in a file called "workbench.settings" (Windows users look at "C:\Documents and Settings\<user>\.sqlworkbench\"). There, the following line has to be inserted:
Now, for SELECT statements in the DbExplorer view of SQL Workbench/J all column values of type geometry get through this function.