An easy and powerful visual development system for database design, modeling, creation, modification and reverse engineering. Accelerates the process of PostgreSQL database creation. It's easy!
Version: 1.13.1Database Designer for PostgreSQL is an easy CASE tool with an intuitive graphical interface allowing you to build a clear and effective database structure visually.
License: Free To Try $124.95
Operating System: Windows
See the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.
Database Representation:Place objects of your database on a diagram, a virtual sheet of paper.
See and realize the structure of your database and its objects: tables, views, stored procedures, functions and relationships between them. Construct schemas, domains, tables, indexes, columns and triggers.
You can import already existing databases to a diagram by reverse engineering.
Easy Database Generation and Maintenance:With the database designer, you can quickly create a ready-to-use PostgreSQL database with just a few clicks, and then keep its structure up-to-date by synchronizing it with the changes you made to a visual diagram. Simply change the diagram, and the Designer will generate the complex SQL statement for database modification to bring it to the state of the diagram, keeping the data safe.
Moreover, you can synchronize several databases to the state of your diagram.
Documentation: Printing, Generating Graphics and Reports:Generate powerful reports that describe all the database objects within your diagram.
You can export a graphical representation of the diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages.
Version 1.13.1: This release introduces Command Palette (Ctrl + Shift + P) from which, you have access to all of the functionality of Database Designer, including keyboard shortcuts for the most common operations.
Version 1.12.2: This release introduces full support for PostgreSQL 10 IDENTITY columns: generation, reverse engineering from both server and SQL, modification. OpenSSL 1.1g used. New icons for editors tabs added.
Version 1.12.1: This maintenance release fixes bug with sequence Reverse Engineering and introduces support for PostgreSQL 10.1 minor release.
Version 1.12.0: This release introduces preliminary support for PostgreSQL v10.
Version 1.11.3: This release improves user experience allowing hide unneeded objects. Adds option to not run executor after database generation or modification. Allows run default application associated with .sql files. Fixes two nasty bugs.
Version 1.11.0: This minor release introduces support for upcoming PostgreSQL 9.5 and provides new SSH tunneling facility out of the box. Several bugs were fixed as well.
Version 1.10.6: New release introduces enhanced support for Windows 10 and optional anonymous statistics functionality.
Version 1.10.5: This maintenance release improves logging facility a lot, and fixes several bugs
Version 1.10.4: This is maintenance release which fixes slow Reverse Engineering and Modify Database on some models, improves shell association. Some minor bugs were fixed.
Version 1.10.3: PostgreSQL 9.4 support added. JSONB type support added. Allows creating indexes CONCURRENTLY.