Schemas

1. Right-click the data source and navigate to New | Schema.

2. In the Name field, specify a name of the schema.

3. Click OK.

• You can select the default schema or database by using the list, which is in the upper-right part of the toolbar. When you select the default schema, you can omit the name of that schema or database in your statements.

  Click the <schema> list and select the schema that you need.

  

1. In the Database tool window ( View | Tool Windows | Database) , click the Data Source Properties icon .

2. Select a data source that you want to modify. On the General tab in the Database field, type the name of a schema that you want to use as default.

   

• In the Database tool window ( View | Tool Windows | Database) , right-click a data source and navigate to Tools | Manage Shown Schemas…. Select or clear checkboxes of schemas that you want to enable or disable. Press Enter.

• Click the N of M link near the data source name. In the database and schema selection window, select or clear checkboxes of databases and schemas that you want to enable or disable. Press Enter.

  

1. To display and introspect all the schemas or databases with names that match a regular expression pattern, in the Database tool window ( View | Tool Windows | Database), click the add pattern button.

   

2. In the new filtering node, define the regular expression.

   

   The filtering node with filter can be added under any node, including another filtering node.

note

Multiple patterns combine multiplicities, not intersect them.

note

The All schemas node behaves differently now: it doesn't select the default schema automatically. You need to select between All schemas, Default schema, or a filtering node.

• To display all the available databases and schemas in the Database tool window ( View | Tool Windows | Database), click the Show Options Menu button and select the Show All Namespaces option.

  Enabled	Disabled

1. Select two schemas.

2. Right-click the selection and navigate to Tools | Compare Structure…. Alternatively, press Ctrl0D.

   

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.

1. Click the <session> list, navigate to the list of database schemas (use the arrow icon or press the right arrow key).

2. 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 Alt0↑ and Alt0↓ to reorder the schemas within the search path.

3. To apply the changes, click OK.

   

1. In the Database tool window ( View | Tool Windows | Database) , right-click a PostgreSQL or Amazon Redshift data source and select Properties ShiftEnter.

2. Click the Options tab.

3. From the Switch schema list, select Automatic.

4. Click OK.

   

The Force Refresh action clears the data source information from cache and loads it again from scratch.

• In the Database tool window ( View | Tool Windows | Database) , right-click a data source and select Diagnostics | Force Refresh.

• In the Database tool window ( View | Tool Windows | Database) , right-click a schema and select Diagrams | Show Diagram.