Rollback to Revision 1

Source Link

edited Mar 16, 2018 at 9:32

4.5k
9
34
41

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near ""INSERT" If anyone could let me know any other obvious issues in my code that would be great

Here is the table:

CREATE TABLE employee ( 
    emp_id     integer NOT NULL, 
    first_name varchar(15) NOT NULL, 
    last_name  varchar(15) NOT NULL, 
    manager    integer 
);

And the altering:

ALTER TABLE employee ADD CONSTRAINT unique_emp_id UNIQUE (emp_id);  

ALTER TABLE employee ADD FOREIGN KEY (manager) REFERENCES emp_id;

ALTER TABLE employee ADD CHECK (emp_id != manager)

INSERT INTO employee VALUES
  (1, 'Tom', 'Jones', 2);

INSERT INTO employee (emp_id, first_name, last_name)
  VALUES  (2, 'Dave', 'Smith');

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near "

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near "INSERT" If anyone could let me know any other obvious issues in my code that would be great

Here is the table:

CREATE TABLE employee ( 
    emp_id     integer NOT NULL, 
    first_name varchar(15) NOT NULL, 
    last_name  varchar(15) NOT NULL, 
    manager    integer 
);

And the altering:

ALTER TABLE employee ADD CONSTRAINT unique_emp_id UNIQUE (emp_id);  

ALTER TABLE employee ADD FOREIGN KEY (manager) REFERENCES emp_id;

ALTER TABLE employee ADD CHECK (emp_id != manager)

INSERT INTO employee VALUES
  (1, 'Tom', 'Jones', 2);

INSERT INTO employee (emp_id, first_name, last_name)
  VALUES  (2, 'Dave', 'Smith');

deleted 715 characters in body

Source Link

edited Mar 16, 2018 at 9:19

James Lindsay

3
1
5

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near "INSERT" If anyone could let me know any other obvious issues in my code that would be great

Here is the table:

CREATE TABLE employee ( 
    emp_id     integer NOT NULL, 
    first_name varchar(15) NOT NULL, 
    last_name  varchar(15) NOT NULL, 
    manager    integer 
);

And the altering:"

ALTER TABLE employee ADD CONSTRAINT unique_emp_id UNIQUE (emp_id);  

ALTER TABLE employee ADD FOREIGN KEY (manager) REFERENCES emp_id;

ALTER TABLE employee ADD CHECK (emp_id != manager)

INSERT INTO employee VALUES
  (1, 'Tom', 'Jones', 2);

INSERT INTO employee (emp_id, first_name, last_name)
  VALUES  (2, 'Dave', 'Smith');

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near "INSERT" If anyone could let me know any other obvious issues in my code that would be great

Here is the table:

CREATE TABLE employee ( 
    emp_id     integer NOT NULL, 
    first_name varchar(15) NOT NULL, 
    last_name  varchar(15) NOT NULL, 
    manager    integer 
);

And the altering:

ALTER TABLE employee ADD CONSTRAINT unique_emp_id UNIQUE (emp_id);  

ALTER TABLE employee ADD FOREIGN KEY (manager) REFERENCES emp_id;

ALTER TABLE employee ADD CHECK (emp_id != manager)

INSERT INTO employee VALUES
  (1, 'Tom', 'Jones', 2);

INSERT INTO employee (emp_id, first_name, last_name)
  VALUES  (2, 'Dave', 'Smith');

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near "

Source Link

asked Mar 16, 2018 at 2:59

James Lindsay

3
1
5

"ERROR: syntax error at or near "INSERT" " PostgreSQL error

I am new to SQL and am attempted to create a table, then alter the table to add some constraints with ALTER and finally insert 2 employees, one managing the other. I have been getting this error in pgAdmin4 "ERROR: syntax error at or near "INSERT" If anyone could let me know any other obvious issues in my code that would be great

Here is the table:

CREATE TABLE employee ( 
    emp_id     integer NOT NULL, 
    first_name varchar(15) NOT NULL, 
    last_name  varchar(15) NOT NULL, 
    manager    integer 
);

And the altering:

ALTER TABLE employee ADD CONSTRAINT unique_emp_id UNIQUE (emp_id);  

ALTER TABLE employee ADD FOREIGN KEY (manager) REFERENCES emp_id;

ALTER TABLE employee ADD CHECK (emp_id != manager)

INSERT INTO employee VALUES
  (1, 'Tom', 'Jones', 2);

INSERT INTO employee (emp_id, first_name, last_name)
  VALUES  (2, 'Dave', 'Smith');

postgresql pgadmin-4

Collectives™ on Stack Overflow

Return to Question

"ERROR: syntax error at or near "INSERT" " PostgreSQL error