Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, 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 a few clicks, and then keeping its structure up-to-date by synchronizing it with the changes you made to a visual diagram. Simply change the diagram — Designer will generate complex SQL statement for database modification to bring it to the state of diagram keeping data in 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 graphical representation of diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages.
Software related to microOLAP Database Designer for PostgreSQL
microOLAP Database Designer for MySQL Visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way. Accelerates the process of database creation and makes it clear, simplifies MySQL database maintenance.
pgISQL (Interactive SQL for PostgreSQL) Interactive SQL for PostgreSQL is a powerfull database utility for building, executing and processing queries upon PostgreSQL databases.
EMS SQL Manager 2005 for PostgreSQL EMS SQL Manager for PostgreSQL is a powerful graphical tool for PostgreSQL DB Server administration and development. Its state-of-the-art graphical interface and a lot of features makes creating and editing PostgreSQL database objects easy and fast.
EMS SQL Manager 2007 for PostgreSQL EMS SQL Manager for PostgreSQL is a powerful graphical tool for PostgreSQL DB Server administration and development. Its state-of-the-art graphical interface and a lot of features makes creating and editing PostgreSQL database objects easy and fast.
EMS SQL Manager 2007 Lite for PostgreSQL EMS SQL Manager Lite for PostgreSQL is a light and easy-to-use freeware graphical tool for PostgreSQL administration. It has minimal required set of instruments for those users who are new to PostgreSQL server and need only its basic functionality.
EMS SQL Manager 2005 Lite for PostgreSQL EMS SQL Manager Lite for PostgreSQL is a light and easy-to-use freeware graphical tool for PostgreSQL administration. It has minimal required set of instruments for those users who are new to PostgreSQL server and need only its basic functionality.
EMS PostgreSQL Utils 1.7 PostgreSQL Utils are powerful data management utilities for PostgreSQL Server, which make your work with the server much easier and faster. PostgreSQL Utils include powerful utilities for comparing PostgreSQL databases and discovering differences in their structure, building and executing queries, converting ADO-compatible databases to PostgeSQL, quick exporting and importing data from/to PostgreSQL tables and extracting data and metadata.
PostgresDAC PostgresDAC is PostgreSQL BDE replacement for Delphi 4-6 and BCB 5. It allows to create Delphi/BCB5 applications with direct access to PostgreSQL DB without BDE and ODBC. Interface is BDE-like and TDataSet compatible. JPEGs in BLOBs are supported.
# 1 PostgreSQL Manager - Navicat PostgreSQL Client (supports Access to PostgreSQL) Navicat (PostgreSQL Client - a GUI Tool for PostgreSQL admin and Access to PostgreSQL, Excel to PostgreSQL conversion). Navicat is a set of graphical database management, reporting and monitoring tools for PostgreSQL database systems. Navicat is easy-to-use and powerful.
DBConvert for Access & PostgreSQL DBConvert for Access & PostgreSQL with scheduler converts MS Access (mdb) to PostgreSQL and PostgreSQL to Access. You can save data to PHP script or dump (text) file that allows you to get over the restrictions on access to PostgreSQL database.
