3.3. Tables

Tables or entities, in pgModeler, are containers and stores several kind of other objects like columns, constraints, triggers, rules, indexes and policies. These children objects will be fully detailed in next subsections. The table's editing dialog has the following fields:

Attribute Description
Tag This attribute is used to configure the tag object associated to the table. Tags are used to graphically separate tables and views even if they are owned by the same schema. Details about tags can be seen further in this chapter on section Tags.
With OID Specifies if each tuple in the table should have an OID (Object Identifier) associated. This attribute is considered deprecated and is present in pgModeler just for compatibility reasons but its use is discouraged for new models.
Enable row level security Enables the table's row security policies that restrict, on a per-user basis, which rows can be returned by normal queries or inserted, updated, or deleted by data modification commands. This option only take effect if there are policies associated to the table. Refer to section Policies for details.
Force RLS for owner Indicates that the owner of the table should be subject to the row level security. In PostgreSQL the default behaviour is that table owners normally bypass RLS.
Unlogged Indicates that table should not be monitored by the WAL (write ahead log) system.
Generate ALTER for
columns/constraints
This option, when checked, indicates to pgModeler that all columns and constraints must be generated in form of ALTER TABLE commands. This is useful when you want to do an incremental modeling, that is, create objects in tables that already exists on a running PostgreSQL server. This option was useful when pgModeler lacked the diff tool. Now that the model/database comparing is present, for incremental modeling, we recommend the use of diff process instead of this option.
Columns This tab lists and allows the handling of all columns associated to the table. Refer to section Columns for details.
Constraints This tab lists and allows the handling of all constraints associated to the table. Refer to section Constraints for details.
Rules This tab lists and allows the handling of all rules associated to the table. Refer to section Rules for details.
Indexes This tab lists and allows the handling of all indexes associated to the table. Refer to section Indexes for details.
Policies This tab lists and allows the handling of all policies associated to the table. Refer to section Policies for details.
Tables This tab lists all ancestors of the table. Ancestor tables are the ones that are linked to this table through a generalization relationship. Refer to section Relationships for details.

May 25, 2018 at 08:40