I cannot create a table on PostgreSQL

Question

I was trying to create the following table on PostgreSQL:

CREATE TABLE movies
(
    movie_name VARCHAR(200),
    movie_year INTEGER,         
    country VARCHAR(100),
    genre VARCHAR
    PRIMARY KEY (movie_name, movie_year) 
);

But received the following error message:

ERROR:  error de sintaxis en o cerca de «(»
LINE 7:  PRIMARY KEY 
                 ^
SQL state: 42601
Character: 166

Sorry, my PostgreSQL is in Spanish for some reason, but it basically says that there is a syntax error near the '('.

I´m following a course and the teacher was able to create this table on PostgreSQL without any problems, what am I doing wrong?

@BarbarosÖzhan well, it is an SQL statement... But I'm not particularly opposed to removing it. Be my guest. — Mureinik, Mar 29 '20 at 11:37

score 1 · Accepted Answer · answered Mar 29 '20 at 11:27

1

You're missing a comma after the last column definition:

CREATE TABLE movies
(
    movie_name VARCHAR(200),
    movie_year INTEGER,         
    country VARCHAR(100),
    genre VARCHAR,
    -- Here -----^
    PRIMARY KEY (movie_name, movie_year) 
);

answered Mar 29 '20 at 11:27

Mureinik

297,002
52
306
350

I cannot create a table on PostgreSQL

1 Answers1