Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there anything like MySQL workbench for PostGIS? Something that supports SQL output and geometry types would be nice.


I am trying to implement the Land Administration Domain Model and all I got are the specs ( UML diagrams). I need a tool that can create the models and output code that would create the tables. It needs to support geometry types as the LADM deals with parcels.

share|improve this question

closed as off-topic by Paul White, Phil, bluefeet, Aaron Bertrand Jan 26 '15 at 14:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

You could try GRASS or QGIS., open-source GIS applications. You might be able to get what you want from one of them.

EDIT: I see you're after a data modelling tool with support for spatial data types. I can't see any specific reference with basic google-fu. You may be stuck with building your database model using CREATE TABLE statements and then reverse engineering them into a modelling tool for documentation.

If you have Visio Professional, the database modelling feature of that has a passably good database reverse engineering feature that will work OK with anything that supports an ODBC driver.

Another option might be to get an extensible tool such as Sparx Enterprise Architect and frig the metamodel. However, this might be more work than building your database by hand.

share|improve this answer
Ah no. What I want are tools for designing spatial database schemas. – R.K. Mar 29 '12 at 10:29
@R.K. - you mean a data modelling tool that supports spatial data types? – ConcernedOfTunbridgeWells Mar 29 '12 at 10:33
Yup. Preferably one that supports Postgresql/PostGIS as I'll most probably be using that database. Sorry for the ambiguity. Revised the question. – R.K. Mar 29 '12 at 10:35
@R.K. Maybe one of the more upmarket ones like PowerDesigner might do that, but it's quite pricey. – ConcernedOfTunbridgeWells Mar 29 '12 at 10:37

Not the answer you're looking for? Browse other questions tagged or ask your own question.