Error message when using INSERT INTO

Question

Here is a Student table I coded in postgreSQL (an excerpt):

CREATE TABLE "Student"
(
  ucas_no integer NOT NULL,
  student_name character(30) NOT NULL,
  current_qualification character(30),
  degree_of_interest character(30),
  date_of_birth date NOT NULL,
  street_address character(30) NOT NULL,
  city character(30) NOT NULL,
  post_code character(10) NOT NULL,
  country character(20) NOT NULL,
  phone_no character(15) NOT NULL,
  gender character(6) NOT NULL,
  user_name character(15) NOT NULL,
  "password" character(30) NOT NULL,
  CONSTRAINT pk_ucas_no PRIMARY KEY (ucas_no),
  CONSTRAINT ten_digits_only CHECK (length(ucas_no::character(1)) >= 10 OR length(ucas_no::character(1)) <= 10)
)

Now i'm using the query tool feature of pgAdmin to insert data into the table. Here's the INSERT INTO code...

INSERT INTO Student
VALUES
('912463857', 'Jon Smith', 'A-Level', 'BSc(Hons) Computer Science', '10/06/1990', '50 Denchworth Road', 'LONDON', 'OBN 244', 'England', '02077334444', 'Male', 'jonsmi', '123456');

The problem I'm having is, i'm getting an error message saying the Student table does not exist, when it's clearly in my databse. Here's the error message:

ERROR:  relation "student" does not exist
LINE 1: INSERT INTO Student (ucas_no, student_name, current_qualific...
                    ^

********** Error **********

ERROR: relation "student" does not exist
SQL state: 42P01
Character: 13

Anyone have an idea what's wrong?

Also in the INSERT INTO code, does it matter I wrap the data with a single quote or not? I see some code have single quotes and others don't. — Mr Teeth
– Mr Teeth, Commented Mar 22, 2012 at 0:04

Community · Accepted Answer · 2017-05-23 12:01:33Z

11

you have created a table "Student" and you are trying to insert into a table called Student which are different

try this

INSERT INTO "Student" VALUES('912463857', 'Jon Smith', 'A-Level', 'BSc(Hons) Computer Science', '10/06/1990', '50 Denchworth Road', 'LONDON', 'OBN 244', 'England', '02077334444', 'Male', 'jonsmi', '123456');

This will work

please go through this about qoutes omitting-the-double-quote-to-do-query-on-postgresql

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Mar 22, 2012 at 5:21

PresleyDias

3,7116 gold badges41 silver badges62 bronze badges

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

1 Comment

Mr Teeth Over a year ago

Thank you PresleyDias. It works now. Also thanks for the link, some good info in there.

Milen A. Radev · Accepted Answer · 2012-03-22 00:30:22Z

3

Look for "quoted identifier" in "4.1.1. Identifiers and Key Words".

As for your second question (don't comment on your questions, edit them if related, create new if not) - read the whole "Chapter 4. SQL Syntax" of the manual, but the bare minimum is "4.1.2. Constants".

edited Mar 22, 2012 at 0:30

answered Mar 22, 2012 at 0:19

Milen A. Radev

63.2k22 gold badges111 silver badges112 bronze badges

1 Comment

Mr Teeth Over a year ago

Thank you. I'll look at it and get back to you if I have any problems.

Collectives™ on Stack Overflow

Error message when using INSERT INTO

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related