在VSCode中创建PSQL表时出现奇怪语法错误求助

问题原因 #

• 非常规标识符未加引号：PostgreSQL不允许字段名、表名这类标识符以数字开头，像1st_downs、1st_down_penalties这类字段名必须用双引号包裹，否则会触发语法解析错误，导致VSCode误标红后续的类型关键字。
• 拼写错误：字段percetage_scoring_drives拼写有误，正确应为percentage_scoring_drives。

修正后的建表语句 #

CREATE TABLE nfl_week_three (
    rank INT,
    team TEXT,
    games INT,
    points_scored INT,
    total_yards INT,
    offensive_plays INT,
    yards_per_play DOUBLE PRECISION,
    turnover_lost INT,
    fumbles_lost INT,
    "1st_downs" INT,
    passes_completed INT,
    passes_attempted INT,
    passing_yards INT,
    passing_touchdowns INT,
    passing_interceptions INT,
    net_yards_per_passing_attempt DOUBLE PRECISION,
    passing_1st_downs INT,
    rushing_attempts INT,
    rushing_yards INT,
    rushing_touchdowns INT,
    rushing_yards_per_attempt DOUBLE PRECISION,
    rushing_1st_downs INT,
    penalties INT,
    penalty_yards INT,
    "1st_down_penalties" INT,
    percentage_scoring_drives INT,
    percentage_turnover_drives INT,
    expected_points INT
);

内容的提问来源于stack exchange，提问作者Milan Jakab