PostgreSQL - 插入语句错误,认为要插入的值是列名 [英] PostgreSQL - insert statement error, thinks value to insert is a column name
问题描述
我在我的 Mac 上运行 PostgreSQL 版本 9.5.1 - 我试图做一个简单的插入语句,但它吐出一个我不太明白的错误......出于某种原因,它似乎认为我插入的值之一实际上是列名之一.这是场景...
I'm running PostgreSQL version 9.5.1 on my Mac - I'm trying to make a simple insert statement, but it's spitting an error that I don't quite understand... for some reason, it seems to think that one of the values that I'm inserting is actually one of the column names. Here's the scenario...
\d+ group_members
Column | Type |
------------+-----------------------------+
id | integer |
group_id | integer |
user_id | integer |
role | character varying(255) |
inserted_at | timestamp without time zone |
updated_at | timestamp without time zone |
Indexes:
"group_members_pkey" PRIMARY KEY, btree (id)
"group_members_group_id_index" btree (group_id)
"group_members_user_id_index" btree (user_id)
当我尝试跑步时
insert into group_members (group_id, user_id, role, inserted_at, updated_at)
values (1, 2, ’member’, current_timestamp, current_timestamp);
我收到错误:
ERROR: column "’member’" does not exist
LINE 1: ...user_id,role,inserted_at,updated_at) values (1,2,’member’,c...
^
嗯,是的,我同意,成员"列不存在......但我不确定我是否理解为什么 PostgreSQL 认为这是我的意图.我已经在其他表中进行了多次插入,现在遇到了这样的问题,但我似乎无法插入到这个表中.谁能看到我哪里出错了?
Well yes, I agree, the column 'member' does not exist... but I'm not sure I understand why PostgreSQL thinks that this is my intention. I have made numerous inserts into other tables and had now such problem but I can't seem to insert into this table. Can anyone see where I've gone wrong?
推荐答案
用 'member'
替换 'member'
.
您似乎没有单引号.它是其他一些字符
It seems you dont have single quote. it is some other char
这篇关于PostgreSQL - 插入语句错误,认为要插入的值是列名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!