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: [email protected] [mailto:[email protected]]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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
