Before we start to detail the database objects, it's important to know that all objects handled by pgModeler are implemented in conformance to PostgreSQL versions 9.x to 12.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 to the link specified at the footnotes of each page here. It's important to note that it is not the goal of this documentation to describe in full details 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 meaning that the most used objects will be described first and the rest will be presented in alphabetical listing. In order 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.