Why am I getting this syntax error?

Other SQL Server Topics
1

Hi,
So I am in school for computer programming and currently I am creating a simple login page as of right now but I can't seem to get it to connect to the sql database because it says for almost every line in the sql database that there is a syntax error and I don't know what it is because I don't see any error

CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;

-- DROP'ping tables clear out any existing data
DROP TABLE IF EXISTS users;

-- CREATE the table
CREATE TABLE users(
userId VARCHAR(50) PRIMARY KEY NOT NULL,
email VARCHAR(255) UNIQUE,
password VARCHAR(255) NOT NULL,
firstName VARCHAR(128),
lastName VARCHAR(128),
enrolDate TIMESTAMP,
lastAccess TIMESTAMP,
enable BOOLEAN,
type VARCHAR(2) NOT NULL
);

ALTER TABLE users OWNER TO postgres;

This is currently the database i have using pgadmin can anyone tell me what the syntax errors could be on everyline?????