Skip to content
banshee

CP02 — Unquoted identifiers should be lower case

Group: Capitalisation · Auto-fixable: yes

Postgres folds unquoted identifiers to lower case, so a mixed- or upper-case unquoted name is misleading. This rule lower-cases it (auto-fixable). Quoted identifiers are left untouched. Set policy = "upper" to require upper case instead (default lower).

Example

Section titled “Example”
bad:  SELECT Id FROM Patient
good: SELECT id FROM patient

Configure

Section titled “Configure”

Disable this rule in banshee.toml:

[lint]
exclude = ["CP02"]

Or silence one line with -- noqa: CP02. See Linting.