错误：关系“public.ae_User”的“username”列不存在-Postgresql[重复]

Question

我正在学习postgresql，并用elephantsql制作这个表格：

CREATE TABLE "public.ae_User" (
    "Id" serial NOT NULL,
    "Name" character varying(30) NOT NULL,
    "Username" character varying(16) NOT NULL UNIQUE DEFAULT 'Guest',
    "Email" character varying(30) NOT NULL,
    "Password" character varying(120) NOT NULL,
    "Salt" character varying(40) NOT NULL,
    "User_type" int NOT NULL DEFAULT '0',
    "Deleted" BOOLEAN NOT NULL DEFAULT 'false',
    CONSTRAINT "ae_User_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);

但当我尝试插入到：

INSERT INTO "public"."public.ae_User" (Name, Username, Email, Password, Salt, User_type, Deleted)
VALUES ("Miguel", "adminMiguel", "[e-mail]", "admin", "bla", 3, false)

它返回：

ERROR:  column "username" of relation "public.ae_User" does not exist
LINE 1: INSERT INTO "public"."public.ae_User" (Username, Email, Pass...

Answer 1

您的错误在INSERT INTO"public"中。"public.ae_User"将被INSERT INTO"public"替换。"ae_User"

Answer 2

您应该在列名中使用双引号，因为Postgres将列折叠为小写。

如果列包含大写字母（和/或其他语法冲突），则必须使用双引号

另一方面，对于文本或varchar数据已传递到的列，必须使用单引号

INSERT INTO "public"."public.ae_User" ("Name", "Username", "Email", "Password", "Salt", "User_type", "Deleted")
VALUES ('Miguel', 'adminMiguel', '[e-mail]', 'admin', 'bla', 3, false)

附笔：

在我看来，最好改变你的结构如下：

CREATE TABLE public."ae_User" (
    "Id" serial NOT NULL,
    "Name" character varying(30) NOT NULL,
    "Username" character varying(16) NOT NULL UNIQUE DEFAULT 'Guest',
    "Email" character varying(30) NOT NULL,
    "Password" character varying(120) NOT NULL,
    "Salt" character varying(40) NOT NULL,
    "User_type" int NOT NULL DEFAULT '0',
    "Deleted" BOOLEAN NOT NULL DEFAULT 'false',
    CONSTRAINT "ae_User_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);

INSERT INTO public."ae_User" ("Name", "Username", "Email", "Password", "Salt", "User_type", "Deleted")
VALUES ('Miguel', 'adminMiguel', '[e-mail]', 'admin', 'bla', 3, false)