v1.0.0 Summary Chapter 2: Modeling basics 2. Start modeling 2.2. Version specific fields

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 in order to avoid annoying warnings or even error messages coming from a PostgreSQL server. If you really 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.

Feb 20, 2023 at 11:33