postgresql/no-unnecessary-quoted-identifier

Why this matters

Quoting identifiers that don't require it (no reserved-word collision, no mixed case, no embedded characters) just adds noise. PostgreSQL folds bare identifiers to lower case but preserves quoted ones, so quoted identifiers also force every consumer to quote-match the name. Reserved words, mixed-case identifiers, and identifiers containing special characters are left alone.

Examples

SELECT "id", "name" FROM "users" WHERE "active" = TRUE;

SELECT id, name FROM users WHERE active = TRUE;

SELECT "select" FROM users; -- reserved keyword: must stay quoted

SELECT "MyColumn" FROM "MyTable"; -- mixed case: must stay quoted

Configure it

// eslint.config.js
import postgresql from "eslint-plugin-postgresql";

export default [
  {
    files: ["**/*.sql"],
    languageOptions: {
      parser: postgresql.configs.recommended.languageOptions.parser,
    },
    plugins: { postgresql },
    rules: {
      "postgresql/no-unnecessary-quoted-identifier": "warn",
    },
  },
];

Options

This rule has no options.