Before starting to detail the database objects, it's important to know that all objects handled by pgModeler are implemented in conformance to PostgreSQL versions 10.x to 16.x, thus, often in this chapter, the official PostgreSQL documentation will be referenced. This way, if you have any doubt about any field in the forms you can refer to section SQL commands of the official docs or the link specified in the footnotes of each page here. It's important to note that it is not the goal of this documentation to describe in full detail all the objects in the database (or their DDL commands) but the way they are created in pgModeler.

The following sections are organized by relevancy in such a way that the most commonly used objects will be described first. To avoid repeatedly showing and detailing basic fields in the forms only the attributes related to the object being described will be displayed in the sample pictures.