Ignoring schemas when downloading¶
pgCodeKeeper has a feature of a selective downloading of objects from the database. To download the content of specific database schemas, you should select them on the list of ignored schemas.
List of ignored schemas is a list of schemas and their content that shouldn’t or should be downloaded from the DB.
There are two types of lists of ignored schemas:
- black list
- allows displaying of all the objects except the ones from the specified schemas and the schemas themselves in the list rules;
- white list
- as opposed to the black list, it forbids displaying of all the objects except the ones from the specified schemas and the schemas themselves in the list rules.
In each project, it is possible to create an ignored objects list, applying only to current project. To do this, create the .pgcodekeeperignoreschema file in the project root and fill it with the rules according to the list syntax.
The .pgcodekeeperignoreschema file format is case-sensitive. You should use UTF-8.
If you tick Pattern(REGEX) in the new rule creation window, objects will be searched by a regular expression specified in the object name field.
Example of using the ignoring of schemas in downloading¶
For instance, we need to download all the database objects, except for the objects from the worker schema. Add worker to the list of the ignored schemas, tick Black-list on the interface of the ignored schemas:
Click Apply and Close.
In the project editor, click Changes . There are no objects from the worker schema on the differences panel!
If you need to download the objects from the worker schema only, tick White-list in the ignored schemas interface. As a result, only the objects from the worker schema will be displayed.