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"
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Works for me.
Except that I never use the outdated data type
char(n). And neither should you. See: