special-character-in-identifier (NM012)

Automatic fix is not available.

What it does

Checks for identifiers with special characters.

Why not?

SQL identifiers must begin with a letter (a-z) or an underscore (_). Subsequent characters in a name can be letters, digits (0-9), or underscores.

PostgreSQL won't allow special characters in identifiers without double quotes. This means that if you use special characters in identifiers, you have to always double quote them. That is annoying enough by hand and error-prone.

When should you?

Never.

Use instead:

Remove special characters from the identifier.