2.3. Data type field

The data type is one of the most used fields in pgModeler's forms. The purpose of this control is to quickly assign data type to objects without writing a single line of code. This field is a polymorphic one which means that new fields appear as the user chooses the type that demands some advanced attribute. The data type widget is capable of handle all PostgreSQL built-in types, extended types like PostGiS spatial ones and user-defined types. The picture below shows the basic shape of this control.

The dropdown control Type is the name of the type being configured, there the user can type the name of the data type to quickly locate it without expand the listing completely. In the mentioned listing the user-defined types including domains, extensions, sequences, tables and views are included too, but in this case, their names will be schema-qualified. The next fields L, P and [] means, respectively, the length (for character varying types), the precision (for numeric and some date-time types) and the dimension (in case of the type is an array). The user can check if the type is being configured as desired by checking the field Format. If the user types any unknown data type in the field Type the format field will display the text invalid_type in red indicating that the type being configured is unknown or invalid and trying to assign it to an object will generate errors.

As told in previous before, this is a polymorphic field and sometimes additional fields will be presented to the users. The types which enable additional attributes are the date-time ones like interval, time, timestamp and the PostGiS ones like geometry and geography. Below these additional attributes are displayed.


Feb 4, 2018 at 11:07