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

[Randall, Eric]

Stefan,

Thanks for the info, I'll definitely give it a try.  I mostly use pgAdmin3 and OpenJump but I also use Lightning Admin for PG and MySQL.
http://www.amsoftwaredesign.com/
Not free but cheap when on sale (currently 4.99 for both until tomorrow).

-Eric


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
Stefan Keller
Sent: Wednesday, December 31, 2008 1:13 PM
To: PostGIS Users Discussion
Subject: [postgis-users] What SQL admin tools are you using?


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.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users