Apart from global settings which are applied to the whole workspace, it is possible to adjust the settings of a separate project. To do this, select Properties from the project menu or use hotkey (Alt + Enter by default), then select pgCodeKeeper.
Project main settings¶
- Disable SQL parser for unrelated files opened in SQL Editor allows to disable pgCodeKeeper builder of the project files, which are beyond standard directories (SCHEMA and EXTENSION). This disables the search for errors and object references within these files.
- Use Unix-style newline characters allows to use Unix hyphens in lines, for example, in function bodies, object commentaries etc.
- Timezone for all DB connections allows to select, which time zone to use when connecting to databases.
Settings managing the lists of ignored files for current project. A detailed description of work with the lists see in Ignore List.
To add an existing file, click .
To delete a file, click .
To create a new file, click . The list of rules editor will open, similar to the one on the Excluded objects global settings page.
To edit a file, click . The editor of list of rules from current file will open.
Settings managing project libraries.
Libraries are plugged-in sets of object data which are “glued” with project objects during the comparison with the remote database. Directories (a regular directory with files as well as another pgCodeKeeper project), dumps or remote databases can serve as libraries. Besides, you can compress libraries into a zip-archive, upload them to a server and connect them by specifying the archive’s URL. To add libraries, use corresponding buttons on the side panel.
The libraries are loaded in order, in which they are indicated in the list (the topmost library will be loaded first). To change the order, use corresponding buttons on the side panel.
The Owner column allows setting a new owner for all the objects in the library.
If a library already has an owner, this information will be displayed regardless of other pgCodeKeeper settings.
If you don’t want to use privileges and library object owners, you can disable them in the Ignore privileges column.
If a library doesn’t ignore privileges, they will be displayed regardless of other pgCodeKeeper settings.
Disallow overrides. There might be a situation when a project and a library (or two libraries) contain objects with the same names. There are two ways of processing such situations. When this settings is on, such conflicts will cause the object comparison to stop. When it’s off, it will allow you to ignore the conflicts: the first loaded object will be used. Regardless of the settings, the Object overrides view will be displayed, showing all the conflicts.