Schema Manager

Top Previous Next

Schema Manager allows you to add, edit and delete schemas within the diagram. To open Schema Manager, select the Diagram | Schema Manager menu item.

Schema is a virtual object of a diagram and has no graphical representation. After defining a schema, it appears in the object editors, so that you could attach other diagram objects to it.

Schemas tab

Schema Manager contains a grid that represents schemas available in the diagram and their properties. The schema properties you can change in the grid are as follows:

Schema name

The name of a schema to be created. The name cannot begin with pg_, as such names are reserved for system schemas.


Comment to the schema.


The name of the user who will own the schema. If omitted, defaults to the user executing the command. Only superusers may create schemas owned by users other than themselves.


Set this option off to disable generation of the schema during database generation.


This flag shows if the schema is system and can't be changed by a user.

note Despite the fact that public schema marked as system there is still opportunity to change it's Comment, Owner and Generate options.

The buttons below the list of schemas allow you to perform the following actions:

§Add - add a new schema with the default properties to the end of the list;
§Duplicate - add a new schema with the same properties as the selected schema to the end of the list;
§Delete - remove the selected schema from the list.

Preview tab

The Preview tab displays the SQL statement, which will be executed during the database generation. This statement is made up according to the changes you have made using the previous tabs. Please note that the text within the editor is read-only. The content of this tab updates only when your press the Apply button.