Why is there an error with AUTOINCREMENT?

Question

Python

I want to create a table where the id column will fill itself but gives an error. Here is the code:

curr.execute(
    f"CREATE TABLE orders (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, class text,)

psycopg2.errors.SyntaxError: ERROR: syntax error (example position: "AUTOINCREMENT")
LINE 1: CREATE TABLE orders (id INTEGER PRIMARY KEY AUTOINCREMENT NO...

Answer 1

In postgresql you need to write

CREATE TABLE orders (
id serial primary key,
class text);

https://postgrespro.ru/docs/postgresql/9.6/datatyp...