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 disabling pgCodeKeeper builder of the project files, which are beyond standard directories. 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.
- Bind project to database connection - allows binding a project to a specific DB. It will be impossible to change DB to Eclipse tool bar for this project.
- Timezone for all DB connections allows selecting, which time zone to use when connecting to databases. Not included for MS SQL projects.
- Enable project specific settings - allows enabling some of the global settings for the current project.
- Ignore privileges and owners of database objects - allows disabling the search for differences in the properties of the objects related to DB roles.
- Ignore differences in table column order - allows to ignore the order of colums when comparing the tables.
- Enable full dependencies from bodies of functions and procedures (experimental) - allows searching the dependences on functions and procedures within the bodies of other functions and procedures.
- Simple formatting for VIEVs when reading via JDBC (not recommended by PostgreSQL) - allows using simplified view editing, where all unnecessary brackets are removed from the expression. This format might not be supported in the further PostgeSQL versions.
- Use global ignore list - allows enabling/disabling the usage of a global list of differences from the settings page Excluded objects.
Settings managing the lists of ignored files for current project. A detailed description of work with the lists see in Ignore List.
Edit .pgcodekeeperignore allows changing the default ignored file located in the project’s root.
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 that regulate the uploading of objects from the database. See the Ignoring schemas when downloading section for more details.
Click to add a new object. A new object editor will open.
To delete an object, click .
If you need to change an object’s name, click the name and enter a new one.
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/owners 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.