Issue when creating id field

[ahvahsky2008]

Try to upload mssql table to postgres table. When i try insert data - its raise error. datasets convert uniqueidentifier field to serial4

How manually setup column type?

table.upsert_many(rows = list(data), keys = data.keys, chunk_size=1000)

(psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type integer: "CDEA5888-293A-4D0B-B2DE-0001C633F4FE"

[matecsaj]

Note the create_table command documented here https://dataset.readthedocs.io/en/latest/api.html#database.