Problems running Postgresql query

Question

Probably a very easy question for most of you, but I'm having some problems running this code:

CREATE TABLE Users(
 userId INT SERIAL PRIMARY KEY,
 userName VARCHAR(50),
 userPassword VARCHAR(50),
);

I usually use MySQL but encountered PostgreSQL in a school work. Why is this code not working for me? The database just gives me a syntax error, nothing else is provided for me. The only thing I changed compared to the MySQL code is auto_increment to SERIAL. Thanks in advice!

It should be userid int generated always as identity primary key — user330315
– user330315, Commented Apr 6, 2022 at 14:55

Navneet agarwal · Accepted Answer · 2022-04-06 15:19:37Z

2

If you want auto generated sequential IDs , use bigserial, and the query looks something like this :-

CREATE TABLE Users(
 userId bigserial,
 userName VARCHAR(50),
 userPassword VARCHAR(50),
    Primary Key(userId)
);

answered Apr 6, 2022 at 15:19

Navneet agarwal

2091 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Problems running Postgresql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related