6. Introduction

In order to support the user when designing models or managing databases, pgModeler introduces a set of tools that can be helpful in these two jobs. In case of modeling we have features that facilitate the navigation throughout the model, a database model structure validator, a feature to fix corrupted model files and many others.

In database management field, the user counts with a reasonably featured tool that helps to explore database structures, create database objects from code snippets or typed SQL commands and a data manipulator which is able to handle information held by tables and views. The complete set of advanced tools is: model overview, source code preview, model fix, model objects tree, operations history, model validation, object finder, model restoration, SQL tool, model metadata handler and the command line interface. They will be completely detailed in the next subsections.

Aug 29, 2018 at 10:00