v1.2.0 Summary Chapter 2: Modeling basics 2. Start modeling 2.2. Version specific fields
You're browsing the documentation of a version that is still under development, the features described here may change or even be removed.

2.2. Version specific fields

One of the main pgModeler features is the generation of SQL code from a database model, but depending on the kind of objects the user must take care of the attributes being filled in these objects. Since a DDL command for a specific object can vary from version to version of PostgreSQL, pgModeler tries to handle this situation through its dynamic code generation mechanism that considers the current database version – detected during export – to be used in the process. Throughout pgModeler's forms, it's common to find the warning messages and highlighted field labels as shown in the image below.

The warning message at the bottom is self-explanatory but be sure to think twice when assigning values to the specially highlighted fields to avoid annoying warnings or even error messages coming from a PostgreSQL server. If you need to use these fields then you are obligated to export the model to a server whose version matches the one informed in the field's tooltip.


Oct 31, 2024 at 09:12