Closed simonw closed 4 months ago
The documentation doesn't indicate that this works, but it should work for consistency with how transform
works.
https://sqlite-utils.datasette.io/en/stable/cli.html#cli-create-table
Looking at https://sqlite-utils.datasette.io/en/latest/cli-reference.html there are other commands that should accept multiple primary keys as well:
insert
upsert
insert-files
The transform
command accepts multiple --pk
already.
I tried running this:
And got this schema: