PostgreSQL create table char error

Question

I just started learning PostgreSQL. I tried to create a table:

create table diagnosis(
    mkb10 char(5),
    opis varchar(100) not null,
    constraint pk_diagnosis primary key (mkb10)
);

But I get this error:

ERROR: syntax error at or near "char"

Erwin Brandstetter · Accepted Answer · 2023-11-12 22:25:51Z

0

Works for me.

Except that I never use the outdated data type char(n). And neither should you. See:

answered Nov 12, 2023 at 22:25

187k28 gold badges465 silver badges639 bronze badges

1 Answer 1