#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    155
    Rep Power
    13

    Tool to generate ER diagram from PostgreSQL code


    Hi all. Myself and my sys admin are looking for a free tool which will generate a rudimentary ER diagram from an sql file (PostgreSQL or MySQL, but PostgreSQL is the most important).

    Doesn't need to be anything overly fancy, just a basic ER diagram indicating tables, columns and relationships would suffice.

    I've done a bit of digging but haven't been able to find anything really useful.

    Does anyone have any ideas?

    Thanks,
    Pablo
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,148
    Rep Power
    4274
    try one of the tools here: http://www.databaseanswers.com/modelling_tools.htm


    rudy
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    France
    Posts
    55
    Rep Power
    12
    the only one I know :

    http://www.rbt.ca/autodoc/index.shtml

    never tried but seems cool and has multiple output formats (docbook, dia for example)

IMN logo majestic logo threadwatch logo seochat tools logo