[postgis-users] What SQL admin tools are you using?

[Stefan Keller]

Regaring surveys... I have yet another question:

What PostGIS/PostgreSQL admin tools are you using?

I think up to now there have been three possibilities:

1. GIS built in (GUI)
2. psql (CLI)
3. pgAdminIII (GUI)

Recently I've found a nice alternative to 3. pgAdminIII, called:
4. "SQL Workbench/J" (www.sql-workbench.net).

Stefan

NOTE: Download SQL Workbench/J development build 102.8 (2008-12-31) or
later! 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.