Tool to generate ER diagram from SQL code

[pablogosse]

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

[greg252]

For mySQL, try myERD. Search on google.