postgresql/align-column-definitions

Why this matters

Aligns the name, type, and constraint columns of every `ColumnDef` row inside a `CREATE TABLE`. Multi-line column definitions and shared-line layouts are skipped because source surgery is unsafe in those shapes.

Examples

CREATE TABLE t (
  a TEXT NOT NULL,
  b non_blank_text_64[] NOT NULL,
  c INTEGER NOT NULL
);

CREATE TABLE t (
  a  TEXT                  NOT NULL,
  b  non_blank_text_64[]   NOT NULL,
  c  INTEGER               NOT NULL
);

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/align-column-definitions": [
        "warn",
        {
          gap: 2,
        },
      ],
    },
  },
];

Options

gap integer (>= 1) default: 2

Number of spaces to leave between aligned columns.