change the bookid line in the CREATE TABLE statement above to this: bookid integer PRIMARY KEY, And, SQLite3 will create a table with equivalent settings to MariaDB and PostgreSQL. The INSERT ...

I then logged in to my PostgreSQL instance, launched psql, connected to my database (appsdata), created a new table (hw_devices), and copied the CSV data into it by entering: docker exec -it ...