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.
Siehe auch:
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:
workbench.db.postgres.selectexpression.geometry=astext(transform(${column},4326))
Now, for SELECT statements in the DbExplorer view of SQL Workbench/J all column values of type geometry get through this function.