Schemas
Create a schema
Click the data source in which you want to create a schema.
Navigate to .
In the Name field, specify a name of the schema.
Click Execute.
Select the default schema
You can select the default schema or database by using the list in the right-hand part of the toolbar. If you do so, you'll be able to omit the name of that schema or database in your statements.
Click the <console> list and select the schema that you need.
Show and hide schemas
You can select what schemas you want to show in the database tree view.
In the Database tool window (), right-click a data source and navigate to . Select or clear checkboxes of schemas that you want to enable or disable. Press Enter.
Click the N connections link near the data source name. Select or clear checkboxes of schemas that you want to enable or disable. Press Enter.
To hide all schemas, navigate to .
Compare two schemas
Select two schemas.
Right-click the selection and navigate to Compare.
Set the schema search path for PostgreSQL and Redshift
The search_path environment variable in PostgreSQL specifies the order in which schemas are searched. For example, you set the value of search_path to z,a,public, PostgreSQL will look for a value in the z schema. If nothing was not found in the z schema, PostgreSQL looks for the value in the a schema.
In PostgreSQL and Amazon Redshift, the default search path (the path that is set in a database) is used unless you specify a different search path.
Click the <console> list, navigate to the list of database schemas (use the arrow icon
or press the right arrow key).Select the schema that you want to add to a search path.
To form a search path, you can use the following actions:
Press Space to add a highlighted schema to the search path and to remove a schema from the search path.
Press Alt+Up and Alt+Down to reorder the schemas within the search path.
To apply the changes, press OK.
