PG-friendly CASE/modeling tool?
Hello. We are new to Postgres, and are in the process of migrating our
project's app from Oracle.
I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
for >15 years (and love it!), but its support for Postgres 8.4 is weak
(e.g., missing many datatypes, no function-based indexes, no partial
indexes, etc, etc). I don't get the impression that they're in a rush to
improve it, either.
Can anyone recommend a mature modeling/CASE tool with good support for
recent Postgres features?
Thanks much!
/mcr
On Wed, 2010-08-11 at 13:17 -0400, Michael C Rosenstein wrote:
Hello. We are new to Postgres, and are in the process of migrating our
project's app from Oracle.I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
for >15 years (and love it!), but its support for Postgres 8.4 is weak
(e.g., missing many datatypes, no function-based indexes, no partial
indexes, etc, etc). I don't get the impression that they're in a rush to
improve it, either.Can anyone recommend a mature modeling/CASE tool with good support for
recent Postgres features?
Eclipse has great modeling tools that work with PostgreSQL.
JD
Thanks much!
/mcr
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt