INSERT COMMAND :: ERROR: column "value" does not exist

Question

I'm using postgresql and I'm trying to insert data into a table users. When I do that using

INSERT INTO users (user_name, name, password,email) 
    VALUES ("user2", "first last", "password1", "[email protected]" );

I get the following error:

ERROR:  column "user2" does not exist

This is how the table looks like:

Table "public.users"
  Column   |       Type    |  Modifiers                        
 user_name | character varying(50)  | 
 name      | character varying(50)  | 
 password  | character varying(50)  | 
 email     | character varying(100) | 
 user_id   | integer                | not null default nextval('users_user_id_seq'::regclass)
Indexes:
    "users_pkey" PRIMARY KEY, btree (user_id)

I was able to insert a row, but it is not working now.

Character constants need single quotes. See the manual: postgresql.org/docs/current/static/… — user330315
– user330315, Commented Oct 15, 2016 at 10:14
See also stackoverflow.com/q/1992314/1741542 on single quotes and double quotes. — Olaf Dietsche
– Olaf Dietsche, Commented Oct 15, 2016 at 12:32

YanivGK · Accepted Answer · 2019-06-15 13:19:23Z

46

Character constants need single quotes.

Use: INSERT INTO users(user_name, name, password,email) VALUES ('user2','first last','password1', '[email protected]' );

See the manual: postgresql.org/docs/current/static/…

Note: After I encountered the same problem and almost missed the answer that exists in this page (at the comments section), thanks to @a-horse-with-no-name - I've posted this answer

edited Jun 15, 2019 at 13:19

answered Jul 27, 2018 at 17:23

YanivGK

91312 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

cglacet Over a year ago

I encountered many bad error messages, but this one is quite interesting. I'm pretty sure I'll end up here again in a year or two.

Henry Ecker · Accepted Answer · 2023-02-09 05:19:12Z

2

You use double quotes for VALUES instead of single quotes. That's why you got the error:

INSERT INTO users (user_name, name, password,email) 
    VALUES ("user2", "first last", "password1", "[email protected]");
            ↑     ↑  ↑          ↑  ↑         ↑  ↑               ↑

So, use single quotes for VALUES instead as shown below, then you can solve the error:

INSERT INTO users (user_name, name, password,email) 
    VALUES ('user2', 'first last', 'password1', '[email protected]');
            ↑     ↑  ↑          ↑  ↑         ↑  ↑               ↑

edited Feb 9, 2023 at 5:19

Henry Ecker♦

35.8k19 gold badges48 silver badges67 bronze badges

answered Sep 8, 2022 at 4:11

Super Kai - Kazuya Ito

42.9k23 gold badges259 silver badges258 bronze badges

Collectives™ on Stack Overflow

INSERT COMMAND :: ERROR: column "value" does not exist

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related