Getting "syntax error at or near '('" Postgresql

Question

I am new to SQL. I am getting this error and I'm not sure where is the problem:

syntax error at or near "("

This is my SQL query for postgres:

DROP TABLE IF EXISTS posts;

CREATE TABLE posts (
    title VARCHAR(10000) NOT NULL,
    url VARCHAR(10000) NOT NULL,
    img VARCHAR(10000),
    source VARCHAR(50) NOT NULL,
    content VARCHAR(65535),
    tldr VARCHAR(65535) NOT NULL,
    getTime BIGINT(255) NOT NULL,
    category TINYINT(255)
);

score 1 · Accepted Answer · answered Jul 25 '21 at 09:27

Postgres doesn't have a TINYINT type, it has SMALLINT. And both BIGINT and SMALLINT don't have a width:

CREATE TABLE posts (
    title VARCHAR(10000) NOT NULL,
    url VARCHAR(10000) NOT NULL,
    img VARCHAR(10000),
    source VARCHAR(50) NOT NULL,
    content VARCHAR(65535),
    tldr VARCHAR(65535) NOT NULL,
    getTime BIGINT NOT NULL,
    category SMALLINT
);

Getting "syntax error at or near '('" Postgresql

1 Answers1