When comparing pgModeler vs ERBuilder, the Slant community recommends ERBuilder for most people. In the question“What are the best relational database design and modelling tools?” ERBuilder is ranked 4th while pgModeler is ranked 12th.
Ranked in these QuestionsQuestion Ranking
Pro Diff scripts
Can generate scripts to synchronize a database.
Pro Reverse engineering
Can generate diagrams from an existing database.
Pro Export formats
Can export to SQL script file, PNG, SVG or directly to PostgreSQL.
Pro Ease of use
Pro Supports many databases
Pro ER Builder is aasy to use and a complete modeling tool
Very interesting tool, powerful and easy to use. Can do reverse and forward engineering, generate SQL script, and more.
Only 8 Mb install size.
Pro Not limited
The free version does not seem limited (for personal use).
Pro Supports Amazon Redshift data modeling
Can't be compiled in Microsoft Visual Studio because of gcc/clang extensions.
Instructions on how to compile for Windows.