PSQL [错误] - 值被识别为列 [英] PSQL [error] - value being recognized as a column

问题描述

我几天前才开始学习数据库.我遇到了这个问题，我的值被识别为一个列，它吐出一个错误.

I just started learning database a couple of days ago. I'm running into this problem where my value is being recognized as a column, and it's spitting out an error.

这是我的新闻表:

id | bodyText | url |  createdAt | updatedAt 
----+----------+-----+-----------+-----------

这是我在 psql 中运行的命令:

this is the command I ran in psql:

INSERT INTO "News" ("bodyText") VALUES ("this is a test");

这是我得到的错误:

ERROR:  column "this is a test" does not exist
LINE 1: INSERT INTO "News" ("bodyText") VALUES ("this is a ...

我尝试删除双引号，添加它，逐行执行，但到目前为止我还没有找到答案.有没有人对此有答案?提前致谢.

I've tried removing the double quotes, adding it, doing it line by line, and so far I haven't come across an answer. Does anyone have an answer to this? Thanks in advance.

推荐答案

试试这个:

INSERT INTO "Notifications" ("bodyText") VALUES ('this is a test');

这篇关于PSQL [错误] - 值被识别为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！